Power BI Weekly
Issue #260 - 28th May 2024
Only a single (official) announcement this week, which is the GA of the Power Automate Visual – Embed Workflows Directly Within Your Power BI Reports, which now includes the ability to easily switch environments. Chris Webb has also amplified a small M update, and that's the introduction of Module.Versions Function In Power Query, which will mainly help folks creating custom connectors apply certain features to certain versions. Elsewhere this week, Rita Fainshtein has described When to Use Heatmaps and How to Implement Row-Level Heatmaps in Power BI, using matrices instead of the default heatmap to achieve more granular coverage. Finally, Laura-Jayne Adamson has made us all aware that The Countdown Is On for the Fabric Trials, explaining how very soon you'll have to switch over to a paid capacity or risk losing any Fabric items against Trial workspaces. So make sure you address this quickly!
🛠️ Data Prep
- Chris Webb (@cwebb_bi) blogs about Module.Versions Function In Power Query
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) explains how to Find All Errors in All Columns using Power Query in Power BI
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) walks through Understanding apply semantics for window functions in DAX
- Marc Lelijveld (@MarcLelijveld) describes Improving Semantic Model Documentation with AI in Power BI
- Bernat Agulló Roselló (@AgulloBernat) writes about Comparing arbitrary date ranges in Power BI
- Chandeep Chhabra (@chandeep2786) talks about Allocation Calculations in Power BI | Case Study
- Reid Havens (@HavensBI) covers Learning Advanced Text Filters with the DAX Query View
- On the Select Distinct blog, David Laws (@SelectDistLtd) blogs about Unlocking the Power of DAX LOOKUPVALUE in Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Roseanne Levasseur (@MSPowerBI) announces Power Automate Visual GA – Embed Workflows Directly Within Your Power BI Reports
- On the Learning Science YouTube channel, Learning Science talks about Power BI Line chart new features - May 2024 update and covers Power BI Matrix Visual new features - May 2024 Update
- On the Power BI community blog, Rita Fainshtein writes about When to Use Heatmaps and How to Implement Row-Level Heatmaps in Power BI
🚀 Deployment, Security and Operations
- Patrick Leblanc (@GuyInACube) explains how to Deliver your Power BI subscriptions to OneDrive or SharePoint
- Andrzej Leszkiewicz (@avatorl) writes about Pseudo Row Level Security (RLS) for Publish to Web Power BI Reports
- On the Purple Frog Systems blog, Laura-Jayne Adamson blogs about Fabric Trials: The Countdown Is On
🌐 General
- Miguel Félix covers Atualização Power BI maio 2024 [Portuguese]