Power BI Weekly
Issue #299 - 11th March 2025
No Power BI-specific announcements this week, other than the fact it's the Last Chance to Enter the Power BI DataViz World Championships (ending Friday evening/Saturday morning depending on your time zone). This final week's theme is "Nature & Climate", so if you have any related content then what's the harm in submitting them? We do have one semi-relevant Fabric update this week, which is a summary of the Fabric Admin API updates and upcoming definition changes, with the most interesting update (IMO) being the ability to Update any tenant setting programmatically.
Elsewhere this week, Jess has continued her blog series with the article Encoding categorical data for Power BI: Using label encoded data vs one-hot encoded data in Power BI showing the storage and performance improvements you can make to your semantic model with some simple transformations. Stephanie Bruno has highlighted that Basic Power BI accessibility is easier than you think and references a community tool called Power BI Accessibility Checker that you can use to test out your reports. Finally, Mike Honey has stumbled upon an interesting PBIP fx hack: dynamic expressions for properties - everywhere! which opens up many potential (though presumably "unsupported") customizations previously not possible on your report.
🛠️ Data Prep
- On the RADACAD blog, Reza Rad (@RADACAD_COM) discusses Power Query Library of Functions; Shared Keyword
- On the Power BI community blog, Anmol Malviya describes How to Append Queries in Power BI
🧩 Data Modeling
- On the endjin blog, Jessica Hill (@JessRoseHill_) writes about Encoding categorical data for Power BI: Using label encoded data vs one-hot encoded data in Power BI
- Purna (Chandoo) Duggirala (@r1c1) writes about New vs. Returning Customers Analysis with DAX [Easy Formulas]
- Hariharan Rajendran (@imhariharanr) walks through Transforming Power BI Development with DAX Query View and TMDL View
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) explains How to use RELATED & RELATEDTABLE DAX function in Power BI?
- Reid Havens (@HavensBI) talks about Building Income Statements in Power BI (with Chris Barber)
📊 Report Authoring and Interactivity
- On the SQLBI blog, Marco Russo (@marcorus) discusses [FIXED] Dialog boxes in custom visuals are broken in Power BI Desktop February 2025
- On the Power BI community blog, Mike Honey (@Mike_Honey_) describes PBIP fx hack: dynamic expressions for properties - everywhere
- Also on the Power BI community blog, Trupti Shirsat explains How to add Gradient Text in Power BI Dashboard
- Bas Dohmen (@HowToPowerBI) talks about Special Effects in Power BI Visuals
- Valerie Junk (@porcubi) discusses Heatmap in Power BI and talks about Help Tooltip Button in Power BI
- Parul Sagar (@parulsagar) describes Mastering Visual Calculations in Power BI — A Practical Guide
🚀 Deployment, Security and Operations
- Chris Webb (@cwebb_bi) writes about Refreshing Hidden Tables In Power BI Semantic Models With Fabric Data Pipelines
- On the Fabric blog, Bogdan Blaga (@MSPowerBI) highlights some Fabric Admin API updates and upcoming definition changes
🌐 General
- Vahid Doustimajd (@VahidDoustiM) presents Persian Power BI and Fabric Conference 2025 - Farsi Day - 7th of March [Persian]
- On the Power BI community blog, Stephanie Bruno (@StephTBruno) writes about Basic Power BI accessibility is easier than you think
- On the Power BI blog, Pam Spier highlights the Last Chance to Enter the Power BI DataViz World Championships