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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.