Power BI Weekly
Issue #272 - 20th August 2024
Just a single announcement this week, which is that the Admin monitoring workspace is now available in US government cloud tenants (GCC, GCC High, DoD) - great news if that is relevant to you! On the community side this week, Kurt Buhler has written an intricate blog describing how to Highlight a data point and comparing to all others in a distribution using Jitter Plots, an effective way to make a small number of data points stand-out compared to a bunch of categories. Then, two other blogs that fit quite nicely together this week: Chris Webb has investigated Which Columns Are Loaded Into Memory When In Power BI Direct Lake Mode?, and Teo Lachev has written about Memory Utilization with Interactive Operations in Direct Lake - both useful reads if you're wanting to understand the behaviour of Direct Lake memory management (especially crucial for large semantic models!).
🛠️ Data Prep
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) explains how to Convert Date Datatype correctly using Power Query in Power BI
- Miguel Félix covers Cálculos dinâmicos no Power Query [Portuguese]
- Jeff Lenning (@Exceluniversity) describes how to Split Amount into Annual Columns
- Soheil Bakhshi (@biinsightnz) describes Microsoft Fabric: Troubleshooting Query Parameters in Published Semantic Models
- Rick de Groot (@Rickmaurinus) describes Creating a 445 Calendar (incl 454, 544) in Power Query M
🧩 Data Modeling
- Chris Webb (@cwebb_bi) writes about Which Columns Are Loaded Into Memory When In Power BI Direct Lake Mode?
- On the Learning Science YouTube channel, Learning Science talks about DAX USERRELATIONSHIP function with an example in Power BI
- Morten Lønskov announces Tabular Editor 3: August 2024 Release
📊 Report Authoring and Interactivity
- Kurt Buhler (@kurtbuhler) describes Highlighting a data point and comparing to all others in a distribution
- Reid Havens (@HavensBI) discusses The Power of SVGs in Power BI (Kerry Kolosko) and walks through Creating a Calendar Slicer from a Matrix Table (with Erik Svensen)
- Sunil Mathew (@_sunil_mathew_) describes how to Show Top N with 'Others' in Your Visuals | Power BI Tutorial
- Avi Singh (@powerbipro) explains how to Avoid This Common Power BI Mistake: Why Flat Tables are Bad
- On the Power BI community blog, Someleze Diko (@DikoSomeleze) describes how to Achieve an End-to-End Data Analysis for your data in Fabric Part 2
- Andrzej Leszkiewicz (@avatorl) describes How to Improve your Dashboard Design? and writes 🔴 Use the Analyze Feature to Explain Fluctuations in Report Visuals
🚀 Deployment, Security and Operations
- On the Power BI blog, Bogdan Blaga (@MSPowerBI) shares Announcing: Admin monitoring workspace is now available in US government cloud tenants (GCC, GCC High, DoD)
- On the Prologika blog, Teo Lachev (@tlachev) covers Fabric Direct Lake: Memory Utilization with Interactive Operations and covers Fabric Capacity Limits
🌐 General
- On the Power BI community blog, DataNinja777 writes about Creating lease accounting app using Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 281 - Interview With Charles Webb