Power BI Weekly

Issue #183 - 22nd November 2022

It's a double edition this week with plenty of great content. A few amazing announcements (a couple of which were announced/discussed at the PASS summit), which were the support for paginated reports in Power BI Pro (woop!), the New cache refresh settings available in Power BI Premium, and the new Azure Analysis Services to Power BI Premium automated migration tool. Elsewhere this week, Marco and Alberto has described the new horizontal fusion feature in DAX, Kurt Buhler has summarized the various methods to achieve Measure Selection in Power BI, and Chris Webb has shared a lesser-known method of potentially reducing the size of your model in the blog Why You Should Defragment Your Fact Tables If Youre Using Incremental Refresh In Power BI Premium.

🛠️ Data Prep

Philipp Lenz (@lenz_philipp) describes how to Change the data source from a local directory to OneDrive inside Power BI
Ben Gribaudo (@bgribaudo) writes about Power Query PostgreSQL Data Connector Feature Request: Support “Complex” Columns
Gilbert Quevauvilliers (@GilbertQue) discusses Power Query – Appending text to end of column name
Chandeep Chhabra (@chandeep2786) explains how to Combine Data from Multiple Excel Files with Inconsistent Column Names in Power Query
Jon Acampora (@excelcampus) covers The 3 Benefits of Power Query
James Andrew (@MatadorSoftware) writes about 3 Ways to Simply Compare Matching Values Across Two Files Using Power Query
Ruth Pozuelo Martinez (@CurbalEN) describes how to Query Mastodon API with Pagination and text token in Power BI
Reid Havens (@HavensBI) describes Tracking (NULL) Data Input Field Percentage in Power Query!
On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) provides an Overview Of The Query Editor User Interface In Power BI, describes Taking On Excel BI's Stacked To Ordered Power Query Challenge and explains How To Perform Conditional Full and Partial Text Replacements In Power Query
Gaelim Holland (@_EnterpriseDNA) explains How To Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python
On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) provides an MDX in Power BI tutorial and shares a Tutorial to Create a Power BI Report Using PostgreSQL
Hima Bindu Marri (@sivahimabindu) explains how to Convert HTML data to Plain text in Power BI
Miguel Félix writes about Power query – Alguns conceitos base [Portuguese]
Lars Schreiber (@SchreiberLars) writes Wochendaten auf Tage Verteilen mit Power Query [German]

🧩 Data Modeling

On the SQLBI blog, Marco Russo & Alberto Ferrari introduce horizontal fusion in DAX, Marco Russo talks about Invalid Relationships – The Whiteboard #09 and Alberto Ferrari talks about SELECTEDMEASUREFORMATSTRING – DAX Guide
Kurt Buhler (@kurtbuhler) talks about Measure Selection in Power BI and provides a Power BI Analyze-in-Excel Checklist
Chris Webb (@cwebb_bi) blogs about Performance Tuning Table Visuals With Filters Applied In Power BI
Patrick Leblanc (@GuyInACube) talks about Writing some DAX while looking at Relationships
On the Power BI community blog, Xiaoxin Sheng talks about Sorting Multiple Columns
Marc Lelijveld (@MarcLelijveld) announces Power BI Model Documenter v2.1.0
On Acuity Training, Ben Richardson (@AcuityTraining) explains How To Create Data Models in Power BI
Ruth Pozuelo Martinez (@CurbalEN) describes how to Override drillthrough filters in Power BI
Sam McKay (@_EnterpriseDNA) describes How To Show Percentage Sales Per Custom Group Each Year In Power BI - Advanced DAX [2022 Update], delves into Understanding Anomalies In Power BI With DAX - Analytical Technique [2022 Update] and explains How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update]
On Le CFO Masqué, Kim Leblanc describes how to Grouper des données dans Power BI [French]
Bernat Agulló (@AgulloBernat) writes about The ultimate snapshot report
Dhruvin Shah (@DhruvinShah16) explains how to Generate Power BI Measures in Natural Language Quick Measure Suggestions
Avi Singh (@powerbipro) covers Using the Auto/Date Time Feature in Power BI

📊 Report Authoring and Interactivity

On the Power BI blog, Cookie McCray (@MSPowerBI) announces support for paginated reports in Power BI Pro
On the Enterprise DNA blog, Sue Bayes (@sue_bayes) blogs about Report Builder In Power BI: Formatting Objects & Visualizations and explains How To Format Data In Report Builder
On the Power BI community blog, cfriss describes Dynamic Pareto Charts in Power BI - revisualized Part 1 and Part 2
Reid Havens (@HavensBI) shares the Top Secrets of Power BI Report Design with Mara Pereira
Mara Pereira (@datapears) covers Text based conditional formatting in Power BI
On the Towards Data Science blog, Abdullah Kurkcu (@abdullahkurkcu) talks about Creating a Gantt Chart with Power BI
Bas Dohmen (@HowToPowerBI) describes how to Turn any image into an interactive visual in Power BI
Leila Gharani (@LeilaGharani) explains How To Use Drill Through in Power BI
Also on the Enterprise DNA blog, George Mount (@_EnterpriseDNA) talks about R Scripting For Power BI Using RStudio
On the Learning Science YouTube channel, Learning Science explains how to Personalize visuals in a report - Power BI and explains how to Add a live Power BI report page to PowerPoint
Bas Dohmen (@HowToPowerBI) writes about Smart Date Axis
Brian Julius (@_EnterpriseDNA) describes How To Create Dynamic Chart Titles In Power BI
On LaDataWeb, Guido Maroneo writes Efecto visual sobre las cards para “rellenarlas” o “vaciarlas” [Spanish]
Alex Badiu (@BadiuAlexandru) writes about Preattentive Attributes: How It Can Impact Your Report
On the Foresight BI blog, Ahmed Oyelowo (@AhmedOyelowo) covers Understanding Power BI Page Settings (Part 2)

🚀 Deployment, Security and Operations

On the Power BI blog, Ogbemi Ekwejunor-Etchie writes about New cache refresh settings available in Power BI Premium
Also on the Power BI blog, Ogbemi Ekwejunor-Etchie explains how to Accelerate your migration experience from Azure Analysis Services to Power BI Premium with the automated migration tool
Chris Webb (@cwebb_bi) walks through Understanding The Unable to save the changes since the new dataset of size Error In Power BI, describes Why You Should Defragment Your Fact Tables If Youre Using Incremental Refresh In Power BI Premium and walks through Calling The Power BI REST API From TSQL In Azure SQL DB
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Incremental refresh in Power BI—everything you need to know
On the MSSQLTips site, Kenneth A. Omorodion explains how to Configure Incremental Refresh for Non-Query Folding Sources in Power BI Desktop
Also on the MSSQLTips site, Haroon Ashraf discusses Data Masking and Unmasking Strategy for Power BI Report Testers and Business Users
Paul Turley (@paul_turley) discusses Developing and Managing Large Power BI Datasets – Part 1
On the phData blog, Spencer Baucke, Gavin Pedersen, Ahmed Ansari, and Spencer Hamilton describe Implementing Power BI Premium Capacity
Gilbert Quevauvilliers (@GilbertQue) blogs about Using Power Automate to schedule a refresh of a Power BI dataset at the time you want
Olivier Travers (@otravers) covers Power Platform Extranets with AAD B2B Users: Using LastPass to Publish with Power BI Desktop Dataflow & XMLA Access And More
Audrée Pellerin describes how to Partager votre contenu Power BI grâce aux applications [French]
Marcus Wegener (@PowerBIler) writes Power BI Berichte in Business Central Listen einblenden [German]

🌐 General

On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 240 - Interview with Mohammad Ali and Episode 241 - Exciting Paginated Reports News
The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 210
Reid Havens (@HavensBI) explains how to Discover a Learning Framework to Elevate Your PBI Career w/ Steve Campbell
Adam Saxton (@GuyInACube) presents Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022)
On the Enterprise DNA blog, Greg Deckler (@GregDeckler) blogs about Planning Power BI Projects