Subscribe and receive the latest news about Power BI

Power BI Weekly

Power BI Weekly Issue 137: 21st December 2021

Some amazing updates have landed this week, and not just from the new Power BI Desktop release. A feature I've highlighted a couple of times in the past is now out in public preview, and that's Hybrid Tables in Power BI Premium, enabling the possibility to have both Import and DirectQuery partitions within the same table. Not only does this provide you the capability to retrieve the latest data without having to refresh the model, but this also enables you to keep recent data in "hot" mode (i.e. import), and have historical data (e.g. > 12 months old) accessible via DirectQuery in a sort of "cold" mode. This is particularly useful for larger models. In fact, Teo Lachev has described this latter scenario in the blog: Power BI Hybrid Tables. Do check it out.

We've also been notified that Asynchronous refresh now available in Power BI for public preview (yay) and on-demand loading capabilities for large models is now available (yay again, but probably impacts fewer of you). There have also been some Power BI Data Protection December announcements, including the GA of both default and mandatory label policies.

Last, but by no means least, is the Power BI December 2021 Feature Summary, which includes a highly sought-after feature in Sparklines, fixes to some of the issues identified for the new format pane, and the GA of the Paginated Report Visual.

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

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

Archive

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 powerbiweekly@endjin.com.