Power BI Weekly

Issue #33 - 12th November 2019

Blimey, what a packed week last week was. So many announcements and updates to digest... Arun Ulag has got most of them covered in this blog, and for completeness, here are all the referenced blogs:

Be sure to still read Arun's blog, though, as there are numerous other smaller announcements which are just as worthy as the rest (the decomposition tree looks amazing!)

Elsewhere, we've been told about the 50+ New Features in Dataflows this month! and we've been told that it's now possible to Embed paginated reports in your own application for your customers (in preview). On the Azure side, Power BI Integration with Azure Maps is now in preview, and Power BI now supports direct query for Azure Database for PostgreSQL.

Finally, if you want to check out any of the Power BI-related sessions from Ignite, you can find them here: Power BI related sessions at Ignite. My particular favourite is this The future of content lifecycle management in Power BI, detailing the new DevOps features coming to Power BI in the coming months. It's been a long time coming!

🛠️ Data Prep

On the Power BI blog, Miguel Llopis (@mllopis) writes about the 50+ New Features in Dataflows this month!
Matthew Roche (@SQLAllFather) writes a number of blogs: Power BIte: Creating dataflows with linked and computed entities, Power BI dataflows November updates, Diversity of Perspective and Power BIte: Creating dataflows by importing model.json
Nicky van Vroenhoven (@NickyvV) writes about Power Query and The Curious Case of Keep Top Rows
The Azure updates team highlights that Power BI Integration with Azure Maps now in preview and writes that Power BI now supports direct query for Azure Database for PostgreSQL

🧩 Data Modeling

On the Power BI blog, Christian Wade (@_christianWade) writes about the Large models in Power BI Premium public preview
On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Large Datasets: The Good, the Bad, and the Ugly
On the SQLBI blog, Marco Russo (@marcorus) talks about Choosing Azure Analysis Services for large datasets
Brett Powell (@BrettPowell76) provides a Analysis Services vs Power BI Premium Model Feature Matrix
Michael Kovalsky writes about A Case of Incorrect Totals: Default Filters
LC writes about New and Repeat Customers

⚙️ Report Design and Visualizations

On the Power BI blog, Alon Baram describes how to Embed paginated reports in your own application for your customers (Preview)
Darren Gosbell (@darrengosbell) writes about Building custom Data Bars in Power BI using SVG measures
Phil Seamark (@PhilSeamark) writes Creative Aggs Part V : Incremental Aggs
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes about a Stacked Bar Chart
Paul Turley (@paul_turley) writes about Next Level Power BI – SVG Symbols and SVG Databars
Marcus Wegener (@PowerBIler) describes the Creation of an own Power BI report theme
Chris Hamill (@ChrisHamill17) describes how to create a Custom Collapsing Report Navigation Pane
On the Power BI community blog, LC explains how to Make your own News Dashboard in Power BI

⚙️ Data Exploration

On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the Power BI What-If Parameter Feature
Patrick Leblanc (@GuyInACube) asks Can What If parameters help in Power BI reports?
Adam Saxton (@GuyInACube) writes about Different ways to work with Microsoft Excel in Power BI

🚀 Deployment, Security and Operations

On the Power BI blog, Adi Regev (@adi_regev) announces Enterprise Information Management Capabilities in Power BI
Also on the Power BI blog, Anton Fritz (@AntonFritz15) announces the new data protection capabilities in Power BI
Brett Powell (@BrettPowell76) describes Using Get Groups as Admin API
Adam Saxton (@GuyInACube) blogs about Power BI datasets vs. Power BI dataflows – What gets refreshed?

🌐 General

On the Power BI blog, Arun Ulag (@arunulag) writes about Weaving Business Intelligence into the fabric of the organization with Microsoft Power BI
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 124 - Interview with Arun Ulag
Adam Saxton (@GuyInACube) talks about the Power BI Lineage view, MS Ignite and more... (Roundup | Nov 4, 2019)
Carl de Souza (@carldesouza) describes How to Set Up Custom Branding in the Power BI Service