Power BI Weekly

Issue #156 - 10th May 2022

This week we've been told about the New data source and gateway management experience (which is primarily UX changes I believe), and we've been told about the upcoming Changes to the Power BI service – simpler navigation, improvements to lists on Home, and style updates - nothing much of note here other than what's in the title! Elsewhere this week, there are a few developer tips this week. Firstly, Mathias Thierbach has been back on Reid Havens' channel describing Calling the Power BI REST API with VS Code (with Mathias Thierbach) (as a great alternative to using the "Try it" tool in the Power BI REST API docs - which has actually been removed for some reason). Also, James Bartlett has provided a PowerShell script to allow you to Download Report Authored in Browser as PBIX and Marcus Wegener has used pbi-tools to describe how to Copy Power BI data model back to PBIX file.

🛠️ Data Prep

Chris Webb (@cwebb_bi) covers Understanding The “We Couldn’t Fold The Expression To The Data Source” Error In Power BI
Ben Gribaudo (@bgribaudo) writes Zero Rows Can Bite (part 1): The Mysterious Missing Column and announces HubSpot -> Power BI Connector
On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) covers Concatenate List of Values in Power BI using Power Query
Ruth Pozuelo Martinez (@CurbalEN) explains how to Keep most recent record on a table with Power Query | Improved solution
On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) blogs about Reporting data from Azure Cosmos DB using Power BI
Kim Leblanc describes Aperçu des données dans Power Query = un allié pour connaître les propriétés de vos colonnes de données! [French]
On the Learning Science YouTube channel, Learning Science describes how to Extract Key Phases in Power BI Using AI Insights - Just in few clicks
On the Power BI community blog, Vijay Verma explains how to Generate Integer Random Number in Power Query Language M, covers Test for a Number in Power Query M Language and describes Text.ContainsAny and Text.ContainsAll functions in Power Query Language M

🧩 Data Modeling

Brian Julius (@_EnterpriseDNA) explains How To Correctly Count Slicer Selections In Power BI
On the MSSQLTips site, Kenneth A. Omorodion writes about RELATED vs LOOKUPVALUE in DAX: How and when to use them in Power BI
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about CONFIDENCE.NORM, CONFIDENCE.T – DAX Guide and describes NORM.DIST, NORM.INV, NORM.S.DIST, NORM.S.INV – DAX Guide
Avi Singh (@powerbipro) describes Power BI: How to Create Excel Like Fixed/Absolute Reference $A$1 in Power BI
On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about Calculation Groups in Power BI

📊 Report Authoring and Interactivity

On the Blue Granite blog, Eric Lofstrom explains how to Create a Custom Theme with an Image Background
James Andrew describes how to Show More Than Two Items in the Power BI Advanced Filtering Pane | Powerful Workaround and talks about Two Ways to Automatically Set Equal Column Width in Power BI Matrix Visuals
Bernat Agulló Roselló (@AgulloBernat) covers Creating a dynamic KPI card
On the Towards Data Science blog, Jenna Eagleson (@JennaEagleson) describes how to Filter by Manager Hierarchy
Leila Etaati (@leila_etaati) describes how to Change Title of Chart by Selection

🚀 Deployment, Security and Operations

On the Power BI blog, Miquella de Boer (@MSPowerBI) announces the New data source and gateway management experience
Adam Saxton (@GuyInACube) discusses My Excel file is in the cloud! Why isn't refresh working in Power BI?
On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) explains how to Refresh Power BI Datasets via its name instead of Id
Dhruvin Shah (@DhruvinShah16) talks about Refresh Failed: How to refresh table join between on-prem and cloud datasource Power BI?
On the SQL Server Central blog, Dennes Torres (@Dennes) explains How to automate table level refresh in Power BI
On the Power BI community blog, Caitlyn Yan blogs about Transferring ownership of reports in Power BI Service
On the Power BI Tips and Tricks blog, James Bartlett (@JamesDBartlett3) describes Power BI Hack: Download Report Authored in Browser as PBIX
Marcus Wegener (@PowerBIler) describes how to Copy Power BI data model back to PBIX file
Reid Havens (@HavensBI) talks about Calling the Power BI REST API with VS Code (with Mathias Thierbach) and describes Everything You Need to Know about Power BI Goals (with Treb Gatte)
Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 21- Report Authoring and Customization with Power BI Embedding

🌐 General

On the Power BI blog, Dustin Askins announces Coming soon: Changes to the Power BI service – simpler navigation, improvements to lists on Home, and style updates
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) lists the Top Five Mistakes to Avoid When Developing Power BI Reports
On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) writes about Who is the Best Batman in Power BI – A Power BI Analysis of Data
On the Power BI Community blog, Heather Cook Newman (@heddanewman) writes about Learning and Listening Together: Announcing the Microsoft 365 Community Initiative