Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 146: 1st March 2022

The only announcement from this week is that the On-premises data gateway February 2022 update is now available, which is now compatibile with the functionality available in the latest drop of Power BI Desktop. So, elsewhere this week, Soheil Bakhshi has given some handy tips about how to Optimise OData Refresh Performance in Power Query for Power BI and Excel, Gilbert Quevauvilliers has stumbled across a way to get the advanced filtering pane to show more than two items (surely it should be made easier than that!), and Antriksh Sharma has shown how to Use Python to Execute DAX Queries in Power BI & SSAS Tabular - Part 1, using the pythonnet & pyadomd packages which allows integration with the .NET ADOMD library.

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