Power BI Weekly
Issue #224 - 12th September 2023
This week we've been given a few nice announcements - firstly, we've been told about the Dataset Refresh History Enhancements, giving us more useful information about our refreshes in an easier-to-consume manner. We've also been given a Heads up: Power BI OneDrive and SharePoint report viewing will be on by default starting in October. I, for one, think this is a great feature - giving people the flexibility of viewing reports in the app they currently find themselves within (which oftentimes is SharePoint). Next, and probably irrelevant for many of you, there is now support for Azure Active Directory shared device mode (preview) for Power BI Mobile apps, which, if your work phone is only temporarily taken from a pool of shared phones before you hand it back, allows you to sign-in and sign-out of all supported AAD apps in one fell swoop. The Power BI Mobile app is now one of those supported apps.
Elsewhere this week, we've been told that there's now support for calculation groups for Direct Lake datasets, and, more generally, we've been given the Microsoft Fabric August 2023 update, which doesn't tell us anything we didn't already know on the Power BI side (but does give us insights into the developments for the other aspects of Fabric!)
🛠️ Data Prep
- Chandeep Chhabra (@chandeep2786) describes Power Query Tip | View All Columns at Once and explains how to Remove Nulls & Blanks Together | Power Query Trick
- On the RADACAD blog, Reza Rad (@Rad_Reza) shares Power Query Template: One Giant Leap
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) describe Power Query Trim: Explained With Examples
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) explains how to Connect Power BI to Google Big Query
- On the phData blog, Manish Garg (@phdatainc) blogs about Managing Parameters in Power BI Report Builder with Published Data Sources
- Gilbert Quevauvilliers (@GilbertQue) writes about Part 4 – Creating a Power BI dataset and report using DirectLake
- Rick de Groot (@Rickmaurinus) writes about Power Query M vs SQL: A Balanced Perspective
- Tom Martens (@tommartens68) describes How to connect to a local SQL Server instance that is not that local
🧩 Data Modeling
- Zoe Douglas (@MSPowerBI) announces calculation groups for Direct Lake datasets
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes Negative Value in Round Bracket via DAX - Explicit Measure in Power BI Desktop
- Bas Dohmen (@HowToPowerBI) describes Different People = Different KPIs in Power BI
📊 Report Authoring and Interactivity
- On the Power BI blog, Lauren Faber (@MSPowerBI) describes Heads up: Power BI OneDrive and SharePoint report viewing will be on by default starting in October
- Kurt Buhler (@kurtbuhler) covers KPIs and cards in Power BI
- Bas Dohmen (@HowToPowerBI) covers Mastering Bar Charts in Power BI | No More Cut Labels and describes a Histogram with Dynamic Bins in Power BI
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains how to Build Clustered Column Chart and Clustered Bar Chart in Power BI Desktop
- Chandeep Chhabra (@chandeep2786) shares a Resizing Columns Trick in Power BI and describes How to Make a Calendar Dashboard in Power BI
- Kim Leblanc covers Explorez l’interaction sur objet dans Power BI avec ces 3 phases clés [French]
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How to Embed Power BI in SharePoint: 4 Simple Steps
- Leila Gharani (@LeilaGharani) shares the Easiest Ways to Export Power BI to Excel Smoothly and Efficiently (new updates included)
- Bala Madhusoodhanan (@balagmadhu) presents a Running Bar Chat
🚀 Deployment, Security and Operations
- On the Power BI blog, Rui Romano (@RuiRomano) announces Dataset Refresh History Enhancements
- Tom Martens (@tommartens68) writes about Power BI licensing, an eternal mystery, and now - there is also Fabric licensing
- On the Power BI blog, Maya Shenhav (@MSPowerBI) writes about Supporting Azure Active Directory shared device mode (preview) for Power BI Mobile apps
🌐 General
- Ryan Majidimehr (@MSPowerBI) announces Microsoft Fabric August 2023 update
- Kevin Miller (@MSPowerBI) presents Microsoft’s Justice Reform Initiative uses data driven insights to empower communities
- Chris Webb (@cwebb_bi) shares Some Thoughts On Third-Party Tools For Power BI
- Reid Havens (@HavensBI) talks about Starter Extensions for Visual Studio Code and Power BI (with Štěpán Rešl)