Power BI Weekly
Issue #319 - 5th August 2025
Elsewhere this week, there's some AI content on the SQLBI channel, with Kurt Buhler writing a great piece on AI in Power BI: Time to pay attention, describing the potential of MCP servers to complement your Power BI development flows. Also on the AI front, prathyoo has shared a useful prompt to allow you to Document PBIP report using AI. And on the DataViz front this week, specifically matrix visuals, Reid Havens has shown a neat way to achieve Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy, and Davide Bacci is back sharing a very impressive (and entirely native) Matrix Gradient visual, using some clever DAX logic.
🛠️ Data Prep
- Avi Singh (@powerbipro) explains How to Import All Sheets from Excel into Power BI (No Hardcoding)
- On the Power BI community blog, Abhilash Pullakanti discusses Power BI Integration with Databricks
- Nadim Abou-Khalil shares a Fabric Tutorial - Taming Large Data Models in Power BI
- Omid Motamedisedeh covers [Persian] تقسیم ستونها در Power Query: از اصول اولیه تا تکنیکهای پویا
🧩 Data Modeling
- Chandeep Chhabra (@chandeep2786) talks about DAX CALCULATE Explained with 5 Real Examples
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) discusses Taking Power BI Semantic Model to Next Level with Synonyms
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) describes AI Data Schema - Power BI July 2025 Update
📊 Report Authoring and Interactivity
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) discusses AI in Power BI: Time to pay attention
- On the Power BI Tips YouTube channel, Mike Carlo and Tommy Puglia (@PowerBITips) present AI is now Ready - SQLBI - Ep.446 - Power BI tips
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) discusses Storytelling in Power BI using Scatter Chart
- Reid Havens (@HavensBI) talks about Dynamic Matrix Columns in Power BI: Show/Hide Based on Row Hierarchy
- Nadim Abou-Khalil covers Power BI - Beyond Static Charts: Building an Interactive Pie Chart That Actually Tells a Story
- Laura Graham-Brown (@Laura_GB) describes how to Improve a card with SVG
- Valerie Junk (@porcubi) talks about Conditional formatting based on user login in Power BI
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about Power BI Visual Calculations Just Got Smarter with ORDERBY | Power BI Update - July 2025
- Philipp Lenz (@lenz_philipp) writes about Translytical – or how to write data in a database
- Davide Bacci shares a Matrix Gradient visual and describes how to Show Impacted Record Count on Slicer using SVGs
🚀 Deployment, Security and Operations
- On the Power BI blog, Tori Pinheiro (@MSPowerBI) announces that the Standalone Copilot in Power BI will be turned on by default in September
- Also on the Power BI blog, Leo Li announces the On-premises data gateway July 2025 release
- On the Power BI blog, Nikita Takru (@NikitaTakru) announces Introducing the First-Ever Fabric Notebooks Competition for Power BI
- Marc Lelijveld (@MarcLelijveld) writes about Your Metrics, Your Rules: Extracting and Storing Fabric Admin and Capacity Metrics Data in Fabric
- Chris Webb (@cwebb_bi) writes about Why Do Power BI Copilot AI Instructions Seem To Work Better in Desktop Than In The Service?
- Gilbert Quevauvilliers (@GilbertQue) walks through Running a Power BI Performance load test using Visual Studio Code
🌐 General
- On the Power BI community blog, Bhavin Vyas writes about 10 Power BI Tricks Every Analyst Should Know in 2025
- Also on the Power BI community blog, prathyoo describes how to Document PBIP report using AI
- On the Power BI Community blog, Shannon Lindsay (@shan_gsd) shares the 🌟 Judges’ Favorites: Honoring More Standout Entries from the PBI10 DataViz Contest and answers How are Fabric Community Dataviz Contests Judged?