Power BI Weekly

Issue #26 - 24th September 2019

Half a year's worth of issues already. Thank you to everyone who has subscribed, and those that regularly check the newsletters out on the website! Keep spreading the good word :) Anyway, here are the two main announcements from the Power BI team this week:

There have also been a few updates to Azure Analysis Services - see those further down the newsletter, or have a look on the Azure Updates site.

Elsewhere this week, Lars Schreiber has written about Tables in Power Query – how, when and why, and Matt Allington has announced the free upcoming webinar: Introduction to DAX for Power BI, so be sure to check that out!

🛠️ Data Prep

On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Only Get the Last Few Periods of Data into Power BI using Power Query Filtering
Abu Hasan writes about Multiple replacements in a Column using Power Query
On the Power BI community blog, Michal Dvorak (@nolockcz) writes Power Query Enter Data Explained
On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) blogs about The Get Data User Experience in Power BI / Power Query
Lars Schreiber (@SchreiberLars) talks about Tables in Power Query – how, when and why
On the Excelguru blog, Ken Puls (@kpuls) writes that Column Quality and Distribution Features are Finally Here
Gilbert Quevauvilliers (@GilbertQue) writes about Power Query – Getting the Min Value repeated for all rows in my table
The Azure updates team provides a number of AAS updates: Improved query replica synchronization in Azure Analysis Services is in development, Azure Analysis Services scale-out improvement, Azure Analysis Services—Two new higher compute SKUs are now available and Azure Analysis Services diagnostic logging improvements for scale-out

🧩 Data Modeling

On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about the ALL Function in Power BI – How To Use It With DAX and walks through Ranking Insights Using TOPN In Power BI
Matt Allington (@ExceleratorBI) highlights the Free Webinar: Introduction to DAX for Power BI
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) writes about Strong and weak relationships in Power BI
Patrick Leblanc (@GuyInACube) describes how to Use other tools with the Power BI data model
Chandeep Chhabra (@chandeep2786) writes about the RELATED Function Not Working
Daniil Maslyuk (@DMaslyuk) covers TRIMMEAN in DAX
Chris Webb (@cwebb_bi) discusses Power BI Custom Format String Examples, Part 2: Dates And Times
On the PowerPivotPro blog, Rob Collie (@robcolli3) provides A Brief Treatment of DIVIDE(), RANKX(), and “N/A”

⚙️ Report Design and Visualizations

On the edureka blog, Komal walks through Everything You Need To Know About Power BI Charts

⚙️ Data Exploration

Adam Saxton (@GuyInACube) describes how to Export data with Power BI Paginated URL Parameters

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that the On-premises data gateway September 2019 update is now available
Brett Powell (@BrettPowell76) talks about Power BI Premium Registered Servers
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) discusses Updating PBIX Files in SharePoint: Do's & Don'ts

🌐 General

On the Power BI blog, Christopher Finlan (@cmfinlan) provides the Paginated Reports in Power BI September 2019 Feature Summary
Adam Saxton (@GuyInACube) talks about Football, Power BI Desktop update and more... (Roundup | September 16, 2019)
Patrick Leblanc (@GuyInACube) discusses The new Power BI Mobile look (September 2019)
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 118 - September 2019 Power BI Desktop Update
On the RADACAD blog, Reza Rad (@Rad_Reza) writes about the Power BI Training Self Assessment: What Training Path Should I Take?
On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about Power BI Workbooks vs Datasets
Nicky van Vroenhoven (@NickyvV) writes about the Power User Days Belgium - September 2019 Edition