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?