Power BI Weekly Issue 78: 29th September 2020
Wow - what a week. How did everyone find Ignite? Sooo many exciting announcements. If you haven't already, you should take a look at the Driving a data culture in a world of remote everything blog by Arun Ulag, which provides a summary of the announcements. A few of them worthy of stand-alone articles, including the new Power BI Premium per user license (a personal favourite of mine, lowering the barrier to entry of Premium features), the New Power BI experiences in Microsoft Teams, the Smart Narrative visual (providing a smart, textual summary of insights on the page), Power BI for HoloLens 2, and the deployment pipelines General Availability (GA).
And if that's not enough, we've been given the Power BI September 2020 Feature Summary including changes to the lineage view in the Service, data-point rectangle select on more visuals, workspace search during pbix publishing, amongst other updates. Not only that, but we've been given the On-premises data gateway September 2020 update and been given more details about the the Upcoming Evolution of Power BI Premium to enterprise markets and beyond.
Finally, if you can't get enough of conferences, it's SQLBits week this week, and many of us at endjin are presenting, primarily talking about all-things data and Azure. There's still time to sign-up if you're interested - it will definitely be worth it!
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Matthew Roche (@SQLAllFather) discusses Refreshing only upstream dataflows and runs through some Patterns for adopting dataflows in Power BI
- On the Excelguru blog, Ken Puls (@kpuls) walks through how to Use Excel Tables to Filter a Power Query
- Parker Stevens (@PowerBIElite) provides a tutorial on Connecting to Excel in SharePoint Online from Power Query
- Gerhard Brueckl (@gbrueckl) walks through Connecting Power BI to Azure Databricks
- Belinda Allen (@MsBelindaAllen) discusses Creating Data Parameters with Suggested Values in Microsoft Power BI
- Also on the Enterprise DNA blog, Melissa de Korte blogs about Using The Offset Function In Extended Date Tables, explains How To Remove Duplicate Rows In Power Query Based On Conditions and how to Unpivot Multiple Column Pairs In Power Query
- On the Enterprise DNA blog, Brian Julius blogs about Data Masking For Sensitive Information In Power BI and explains how to Calculate Workdays Between Two Dates In Power BI
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) discusses how to Quickly Create Running Totals in Power Query
- Matt Allington (@ExceleratorBI) writes about how to Fast Track Power BI Dev With SharePoint Files
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) provides an Anomaly Detection Calculation Using DAX (Power BI Tutorial)
- On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) gives an Intro to Calculated Columns
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) runs through Understanding Explicit vs Implicit measures in Power BI
- Chandeep Chhabra (@chandeep2786) describes the KEEPFILTERS Function in DAX
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays! #185: Calculating max values by category
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) walks through Building Your Data Model Relationships In Power BI, Active And Inactive Data Relationships In Power BI, Getting Started W/ DAX In Power BI, asks: What Are The Different Data Table Types In Power BI? and discusses Building Data Dimensions In Power BI
- Brian Julius discusses Sorting Date Table Columns In Power BI
- Shabnam Watson (@ShbWatson) explores How much you can save by splitting Date Time columns into separate Date and Time columns in Power BI models
- On the Power BI Community blog, Amit Chandak (@amitchandak78) writes Customer Retention Part 3: Period Of Stay – Cohort Analysis
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about the Linaje de una medida [Spanish]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Ancy Philip (@ancyphilip) writes about the Smart Narrative (preview)
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) gives a Power BI Smart Narrative Visual Review – Is It Ready for Primetime??
- Parker Stevens (@PowerBIElite) describes How to Use the New Smart Narrative Visual Text Box in Power BI
- On the Power BI community blog, Pragati talks about how to use a Slicer to Select Number of Words to be Displayed in a WordCloud in Power BI
- On the Forsight BI blog, Zainab Balogun describes How To Use Scatter Charts in Power BI
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about a scenario: No slicer selected—No chart in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Create a Stacked Column Chart in Power BI, explains how to Create a Stacked Bar Chart in Power BI, provides a demo for how to Show or Hide a Power BI Visual Based on Selection and discusses the Smart Narrative in Microsoft Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes Using a Rose chart in power bi to analyze amazon fires
- Reid Havens (@HavensBI) runs through Adding Drillthrough Filter Breadcrumb Trails to Visual Titles in Power BI
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) describes how to Create Custom Visual Bullet Chart with Charticulator with two categories
- On the CSG Pro blog, Rebecca Mccarthy and Kelsey Wiggin discuss Creating Successful User Centered Reporting in Power BI
- Jarret Moore explains How To Select A Colour Theme For Your Power BI Reports and talks about Setting Up Backgrounds For Power BI Reports Using PowerPoint
- Dhruvin Shah (@DhruvinShah16) blogs about how to Show Total in Stacked Bar and Column Chart in Power BI, how to Maintain Layer Order for your Power BI Report and discusses the Smart Narrative Visual in Power BI
- Gil Raviv (@gilra) highlights a New version of a Custom Visuals Exploration Tool
- Belinda Allen (@MsBelindaAllen) discusses Displaying Images in the Data using Microsoft Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Christopher Finlan (@cmfinlan) is Answering your questions around the new Power BI Premium per user license
- Also on the Power BI blog, David Magar announces the Upcoming Evolution of Power BI Premium to enterprise markets and beyond
- John White (@diverdown1964) highlights that Power BI Announces Premium-per-User licensing and introduces The new Power BI Premium Gen-2 Architecture
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) asks: What is Premium Per User License for Power BI, and What is it good for?
- Also on the Power BI blog, Nimrod Shalit announces the deployment pipelines General Availability (GA)
- Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that On-premises data gateway September 2020 update is now available
- Patrick Leblanc (@GuyInACube) shares why you should STOP publishing your Power BI report until you do these 5 things
- Adam Saxton (@GuyInACube) says that Power BI Publish to Web can be SCARY
- Adam Saxton and Patrick Leblanc (@GuyInACube) provide a recording of their 🔴 Power BI tips from the Pros – LIVE /w Chris Finlan (Sept 26, 2020) (Member Chat 2nd Half)
- Dhruvin Shah (@DhruvinShah16) highlights that you can now Search for a Worksapce during publish
- On the Modern Data & AI blog, Dave Ruijter (@DaveRuijter) explains How to add a Service Principal to all Power BI workspaces in one go and How to remove a Service Principal from all Power BI workspaces in one go
- On the MSSQLTips site, Scott Murray explains how to Deploy Reports from Development to Test to Production using the Power BI Deployment Pipelines
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) writes about how to Automate Power BI Export File with Power Automate
- The Power BI team (@MSPowerBI) explains how to Get started with Power BI template applications
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Arun Ulag (@arunulag) describes Driving a data culture in a world of remote everything
- Also on the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) provides the Power BI September 2020 Feature Summary
- Also on the Power BI blog, Maya Shenhav highlights that Power BI App for mixed reality is now available for HoloLens 2
- Also on the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the New Power BI experiences in Microsoft Teams
- Also on the Power BI blog, Miguel Martinez (@maikelson) provides a place to See all the Power BI updates at the Microsoft Business Applications Launch Event
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) provide a Microsoft Ignite Recap and present an Interview with Chris Finlan
- Adam Saxton (@GuyInACube) presents Microsoft Ignite, Power BI updates and more… (Roundup | Sept 21, 2020)
- Ruth Pozuelo Martinez (@CurbalEN) runs through 20 Power BI Desktop September 2020 and Ignite updates in 11 minutes
- Matthew Roche (@SQLAllFather) talks about Data Culture and Stakeholder Buy-In
- Chris Webb (@cwebb_bi) highlights that the Power BI FastTrack Recognized Solution Architect 2021 Nominations are Open
- On the Towards Data Science blog, Peter Hui writes about the Power BI Exam - DA100
- Kasper de Jonge (@kjonge) is Launching Kasper On BI YouTube and Podcast, for everything (Power) BI and Analytics
- Also on the Power BI community blog, Kelly Kaye (@MS_KellyKaye) runs through the Power BI September 2020 Update
- Devin Knight (@knight_devin) provides the Power BI Monthly Digest – September 2020 with Matt Peterson
- Gilbert Quevauvilliers (@GilbertQue) explains how to Copy & paste images into the Power BI Community replies
- Ruth Pozuelo Martinez (@CurbalEN) covers Visualizing the amazon fires: Get data and model it.
- Marc Lelijveld (@MarcLelijveld) highlights the Power BI icon for Diagrams.net to draft full Power Platform Solutions
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.