Power BI Weekly
Issue #205 - 2nd May 2023
It's been a relatively quiet edition this week, although the only announcement that's arrived is particularly cool. We can now Create Power BI reports in Jupyter Notebooks for your live visualization needs. This is really enabling functionality, and I think features like these will start to shape a new hybrid persona bridging the Data Science / Data Engineering / BI developer spaces. If you have Data Scientists in your org for whom Power BI is not currently part of their toolset, then you might like to ease them into the tool with a feature like this. Similarly, if you have Data Engineers that dabble in both notebooks and building BI reports, try to figure out where/if this functionality could assist them in their work. Maybe it's to try to understand key entities they'll need to create in their data model before they start building the star schema, or to get inspiration about how best to visualize certain bits of data. In any case - it's a very exciting feature.
Elsewhere this week - a couple of data modeling blogs. Antriksh Sharma has described the battle between the ALL Functions vs Security in DAX and what you need to be aware of, and Gilbert Quevauvilliers has described How to modify Dynamic Format Strings in Power BI, as the current Desktop UI doesn't provide an easy to do this.
🛠️ Data Prep
- On the MSSQLTips site, Aseel Al-Laham describes how to Change Power BI Reports Source from Multidimensional SSAS Cube to Tabular
- Chandeep Chhabra (@chandeep2786) describes how to Unstack Uneven Rows to Columns in Power Query
- Brian Julius (@_EnterpriseDNA) talks about Three Ways To Avoid The Common Split By Delimiters Trap
- Antriksh Sharma (@AntrikshShar) explains how to Convert Hour Minute Seconds text to Minutes in Power Query
- On the Kohera blog, Kohera (@Kohera_be) explains How to easily parse JSON in Power BI Desktop
- Laura Graham-Brown (@Laura_GB) writes about Using SQL on Dataverse for Power BI
- Gaelim Holland (@_EnterpriseDNA) talks about Finding Similar Matches With Euclidean Distance Using Python In Power BI
🧩 Data Modeling
- On the SQLBI blog, Marco Russo (@marcorus) discusses Rounding errors with different data types in DAX
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains how to Analyze performance when aggregating data in Power BI and DAX Queries
- Kurt Buhler (@kurtbuhler) describes How to unlock new features in Power BI datasets managed with Tabular Editor
- Antriksh Sharma (@AntrikshShar) writes about ALL Functions vs Security in DAX and describes Installing TOM Library to connect Python to Power BI &38 SSAS
- On the SQL Server Central blog, Kenneth A. Omorodion (@mssqltips) describes How to Slice Data by Week in a Calendar Table using DAX
- Sue Bayes (@sue_bayes) writes about DAX Debugging in Tabular Editor 3
- Sam McKay (@_EnterpriseDNA) describes how to Find Weekday & Weekend Day Numbers Within Months - Advanced DAX [2023 Update]
- Koen Verbeeck (@Ko_Ver) covers Star Schema vs Snowflake Schema Considerations
- On the Select Distinct blog, Select Distinct (@SelectDistLtd) describes Rolling Averages and Rolling Sums in Power BI
- Gilbert Quevauvilliers (@GilbertQue) explains How to modify Dynamic Format Strings in Power BI
- Brian Julius (@_EnterpriseDNA) explains How To Use The Dynamic Format Strings Feature - Power BI April 2023 Updates
📊 Report Authoring and Interactivity
- On the Power BI blog, Noam Raveh (@MSPowerBI) explains how to Create Power BI reports in Jupyter Notebooks
- Bernat Agulló Roselló (@AgulloBernat) covers A nice background always, with the minimum effort
- On the Learning Science YouTube channel, Learning Science explains how to Apply all slicers and Clear all slicers buttons in Power BI
- Davide Bacci shares the Deneb Showcase containing all the creations over the past few months
- On the Power BI community blog, Abbas Godhrawala shares Learn How to Display Text Labels Inside Bars for Clear and Space-Efficient Data Visualization
- David Eldersveld (@dataveld) explains how to Heighten Data Literacy with the Power BI Natural Language Q&A Visual
- On the MSSQLTips site, Kenneth A. Omorodion (@mssqltips) describes how to Change the Default Output on a Power BI KPI Visual
- Reid Havens (@HavensBI) covers Power BI Visual Revolution - AMA (Ask me anything) with Miguel Myers
- On the Towards Data Science blog, Thomas A Dorfer (@ThomasADorfer) describes Quick and Easy Time-Series Forecasting in Power BI: A Practical Guide
- Vahid Doustimajd (@VahidDoustiM) covers PAC-MAN Meets Power BI: How to Add Retro Fun to your reports
- Sue Bayes (@sue_bayes) explains how to Create a linked Excel table from your Power BI report
🚀 Deployment, Security and Operations
- Reid Havens (@HavensBI) walks through Governing Sensitive Data Using Microsoft Purview (with Anton Fritz)
- Ted Pattison (@TedPattison) delves into Power BI Dev Camp Session 32 - Design Guidelines and Best Practices with Power BI Embedding
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Dynamic Row Level Security in Power BI
- Chris Webb (@cwebb_bi) discusses Measuring Memory And CPU Usage In Power BI During Dataset Refresh and covers Understanding WaitTime In Power BI
- Soheil Bakhshi (@biinsightnz) covers Power BI Governance, What Organisations Need to Know
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 254 - Interview with Emily Lisa
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe How to Use Chat GPT for Power BI
- Ryan Palmer and Allen Kim (@MSPowerBI) talk about Microsoft's Airband Initiative uses Power BI to advance Digital Equity