Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 158: 24th May 2022

It's the Build conference this week, and many of you may already be aware that there are some pretty huge announcements on the Power BI front. Yesterday, the (now) announced Datamarts feature started trickling into some tenants, with initial impressions assuming it's a combined data prep and model authoring experience built-in to the Power BI Service. This is pretty much it - essentially Datamarts brings together Dataflows and Data modeling, with a managed SQL DB behind the scenes powering everything. So you ingest your data as usual from various sources using Power Query, then create relationships/measures/calculated tables etc using the model authoring experience. What's more is that you'll get a SQL endpoint to query the underlying data, but they'll also generate an automatic Power BI dataset based on the Datamart. A very compelling argument to keep the simpler workloads within Power BI - again, reducing complexity and lowering the barrier to entry for many users. What a brilliant feature! Take a look at the demo of it here: Add Data at Scale | Datamarts in Power BI.

Another amazing feature that may not get the limelight is the new Power BI integration for PowerPoint. That's right - embed Power BI reports into your slide deck and interact with them during your presentation. Wow! Elsewhere, we've also been told that Goals in Power BI is becoming ‘metrics’ and is moving to GA (Microsoft does love a good rename), and we've been told about the preview of Exportable Formatted Data Tables (which must still be being rolled out to tenants, because I can't yet see that option!) For all the other announcements living in the shadow of Datamarts, view Arun's blog here: Democratize enterprise analytics with Microsoft Power BI.

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