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