Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 122: 10th August 2021

Some amazing announcements this week. The biggest one (IMO) came somewhat out of the blue, which is the public preview of Power BI REST API support for DAX Queries (yes - you read that right!) This will open up so many extensibility possibilities which aren't limited to Premium-only workspaces. So excited for that one. Not only that, but we've also been told about the:

Elsewhere this week, Ken Puls has described a method to Label Duplicates with Power Query to keep track of original records amongst the copies, and Marco and Alberto have written about a common conundrum when modeling data in Power BI - whether to choose a Date or Integer to represent dates in Power BI and Tabular. Long story short - it doesn't make a huge difference, but using a Date as the key column often makes writing your DAX simpler and slightly more performant. Take a read for the justification!

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