Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 120: 27th July 2021

We were hit with both the Power BI July 2021 Feature Summary and the 2021 release wave 2 notes in the last few days. The highlight from the feature summary is arguably the new conditional formatting functionality, which now offers loads more properties to which you can apply rules. As for the release notes, my highlights are the upcoming functionality to provide Artifact-level access for Power BI apps (preview later this year), Natural language to DAX generation (preview early next year) and (for you admins out there), Chargeback reporting for Power BI Premium administrators (in preview early next year).

Another long-awaited feature has landed this week, which is that the Connected PivotTable refresh in Excel for the web is now 100% available to Office tenants, allowing you to interact with Power BI dataset connected Excel PivotTables in Excel online as well as in Desktop. So no more only-cached reports! Also, the Visualizing SharePoint lists feature is now available to all users after a targeted release.

Elsewhere, Yitzhak Kesselman has written an interesting article peeking Behind the scenes: Running the Power BI service, and Reid Havens has dived deep into the Semantics of DAX Queries & Caveats to Composite Models with Jeffrey Wang.

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