Power BI Weekly

Issue #31 - 29th October 2019

The now GA Automated Machine learning in Power BI looks awesome - not had a chance to play with it myself. But the way Power BI/Microsoft seems to be democratizing AI at the moment is pretty incredible. There have been a few other numerous updates and announcements in the last week:

This week Matthew Roche has written a thought-provoking article about the successful implementation of BI within a business, writing that It all comes down to culture. Have a read! Elsewhere, Prathy Kamasani describes how to get a Power BI Card visual to show flags/warnings , and Marc Lelijveld has described how to Move dataflows across workspaces with the Power BI REST API.

🛠️ Data Prep

On the Power BI blog, Ancy Philip (@ancyphilip) announces the Automated Machine learning in Power BI general availability
On the RADACAD blog, Leila Etaati (@leila_etaati) provides an Overview of Available AI and ML capabilities in Power BI
On myOnlineTraininghub, Mynda Treacy (@OnlineTrainingH) describes how to Extract Values Present in Two Lists
On the Power BI Tips and Tricks blog, Steve Campbell provides a Historical Stock Price Function in Power Query
Chandeep Chhabra (@chandeep2786) explains how to Calculate Custom Fiscal Year and Quarter in Power Query
Imke Feldmann (@TheBIccountant) provides a Performance tip for aggregations after joins in Power Query and Power BI
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses Power BI Query Parameters: Optimizing Tables
Matthew Roche (@SQLAllFather) shares a Power BIte: Sharing and reuse with dataflows and datasets and describes Using and reusing Power BI dataflows
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) provides a tool to Make PBIDS Files

🧩 Data Modeling

Chris Webb (@cwebb_bi) writes about Excel PivotTable Query Performance With Analysis Services, Power Pivot And Power BI (Revisited)
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX, Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX, Power BI Exchange Rates: An Update To Multiple Currencies Management, Power BI Data Sets: Learn How To Detect Abnormal Behavior Using DAX and Running Totals in Power BI: How Calculate Using DAX Formula
On the SQLBI blog, Marco Russo (@marcorus) analyzes the performance of DISTINCTCOUNT in DAX
Gilbert Quevauvilliers (@GilbertQue) describes How to see what the actual values are in a FILTER when using a DAX Measure
Phil Seamark (@PhilSeamark) writes Creative Aggs Part II : Horizontal Aggs and Part III : Accordion Aggs
On the Power BI community blog, Amit Chandak (@amitchandak78) blogs about Comparing Data Across Date Ranges
Kasper de Jonge (@kjonge) describes how to Figure out which columns and measures are used in your SSAS Tabular model
Ken Puls (@kpuls) asks How do You Design Your Data Model?

⚙️ Report Design and Visualizations

Patrick Leblanc (@GuyInACube) highlights One little change to improve Power BI slicer performance (BANANAS!!!)
On the Visual BI blog, Vipin Suresh writes about the Advanced Gauge: Custom Visuals for Microsoft Power BI
Prathy Kamasani (@pkamasani) describes how to get the Power BI Card visual to show flags/warnings
On the PowerPivotPro blog, Rob Collie (@robcolli3) writes about the Head to Head Comparison Infographic in Power BI

⚙️ Data Exploration

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces the new contact lists for reports and dashboards in the Power BI service
Patrick Leblanc (@GuyInACube) explains how to Remove CONFUSION in your Power BI report with this little feature

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway October 2019 update is now available
Marc Lelijveld (@MarcLelijveld) describes how to Move dataflows across workspaces with the Power BI REST API
On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) talks about Power BI Workbooks
Adam Saxton (@GuyInACube) describes how to Use Microsoft Flow, and other options, to refresh your Power BI dataset

🌐 General

On the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) provides the Power BI Service and Mobile September 2019 feature summary
Adam Saxton (@GuyInACube) talks about the Worst pie chart ever in Power BI & swords (Roundup | October 21, 2019)
On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Learning About Power BI at Microsoft Ignite 2019 North America: Reza's Sessions
On the Power BI community blog, The Power BI team (@MSPowerBI) highlights some Power BI Training Content
Matthew Roche (@SQLAllFather) writes that It all comes down to culture