Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 140: 18th January 2022

First blog of the year from the Power BI team, with Jeroen ter Heerdt encouraging SSRS users using the Report Viewer control feature to migrate over to use Power BI Paginated Reports and Power BI Embedded, citing all the benefits of migration and the Modern Lifecycle Support Policy under which the Report Viewer Control feature is covered.

Aside from that update this week, we have plenty of great content to highlight. Daniil Maslyuk has written (and spoken) about Power BI Antipatterns #1: SWITCH(TRUE… in DAX. Aaron Watsky has described how to Give users the ability to change a slicer on a published report (mimicking the the dropdown report devs get in Power BI Desktop). And to continue from last week's editorial highlights, James Broome has described how to Test Power BI Reports with the ExecuteQueries REST API (IMO a primary use-case of this endpoint), and Paul Waller has described How to Build a Branded Power BI Report Theme, covering aspects like typography, cover pages, layout, and much more!

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