Power BI Weekly
Issue #315 - 8th July 2025
Also this week, I'd like to highlight a new blog series my colleague Barry has shared, all about DuckLake. You've probably heard about DuckDB - a high-performance analytical SQL engine over files and databases. However, it was not a Lakehouse format (or catalog) in and of itself, unlike what we get in a Synapse/Fabric Lakehouse which use a combination of Delta tables and a Hive metastore. Instead, DuckLake is a new integrated data lake and catalog format working over existing SQL Database Engines that is designed to provide enhanced performance and flexibility over existing Lakehouse+Catalog architectures. Very exciting - do check out Barry's blogs for more!
                            
                            🛠️ Data Prep
                            
                        
                        - Jon Acampora (@excelcampus) shares Power Query Tutorial: 7 Essential Tips to Master Data Transformation in Excel
 - Valerie Junk (@porcubi) explains how to Merge Tables in Power BI - Join Options
 
                            
                            🧩 Data Modeling
                            
                        
                        - Chris Webb (@cwebb_bi) writes about Power BI Copilot, AI Instructions And Preventing The Use Of Implicit Measures
 - Dan English (@denglishbi) describes Power BI Copilot Summaries honor AI Instructions to provide non-English language responses
 - On the SQLBI blog, Marco Russo (@marcorus) talks about Choosing between DISTINCT and VALUES in DAX
 - Chandeep Chhabra (@chandeep2786) describes how to Use Measures as Columns in Power BI? Yes, It’s Possible
 - Parul Sagar (@parulsagar) writes about The Curious Case of the Missing Blanks in Power BI
 
                            
                            📊 Report Authoring and Interactivity
                            
                        
                        - Reid Havens (@HavensBI) explains how to Add Positive/Negative Color Error Bars Using Visual Calcs
 - On the Power BI community blog, Ilgar Zarbali describes Field Parameters in Power BI
 - Shannon Lindsay (@shan_gsd) shares #PBI10 Dataviz Contest | Frequently Asked Questions
 
                            
                            🚀 Deployment, Security and Operations
                            
                        
                        - On the Power BI community blog, Abhilash Pullakanti writes about Seamless Power BI Report Management with SharePoint & OneDrive
 
                            
                            🌐 General
                            
                        
                        - On the Power BI blog, Carly Newsome (@MSPowerBI) announces Updates to Copilot in Power BI: More ways to see, learn from, and ask about your report data