Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 147: 8th March 2022

It's a pretty short edition this week, with no announcements. I wonder whether that's because lots of people have been preparing for their SQLBits sessions, which is taking place in London (starting today). I'm attending on Thursday, Friday and Saturday, so if anyone's around and wants to meet, feel free to drop me a message! Remember that the event is also taking place virtually, so (I believe) there's still time to sign yourself up - Saturday is a free Community event which anyone can join.

In the newsletter this week, we have a great Power Query Masterclass presented by Melissa de Korte (with content to cover all proficiency levels), Xiaoxin Sheng has described how to replicate SWITCH functionality in Power Query in the blog Custom function with multiple condition logic, and on the "Admin" side, Adam Saxton has written about how to most efficiently Deal with orphaned Power BI workspaces to avoid the "click-tax" of doing this manually in the Power BI Service.

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling


Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs


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