Power BI Weekly
Issue #331 - 28th October 2025
A quiet edition but here are the highlights from the past week: Simplifying Reusable Logic in DAX with User-Defined Functions (UDFs) - DAX User-Defined Functions enable true modularity and reusability in Power BI semantic models, allowing developers to define logic once and reuse it across measures, calculated columns, and calculation groups without code duplication. MCP Server: DAX Performance Tuner - An MCP server that connects LLMs to Power BI models to systematically optimize DAX queries through performance analysis, research integration, and semantic validation to ensure optimizations return identical results.
TMDL View in Power BI: The Game-Changer for Semantic Model Management TMDL View provides a developer-friendly code editor for scripting and bulk-editing Power BI semantic models with IntelliSense, enabling reusable components, version control, and access to advanced features like perspectives.
And finally, Understanding The "Copilot Analyzed Only Part Of The Model Due To Its Size" Warning In Power BI Copilot - Power BI Copilot indexes text columns for natural language queries but has limits of 1,000 text columns and 5 million distinct values; the warning appears when these limits are exceeded and can be resolved by hiding key columns or adjusting the data schema.
🛠️ Data Prep
- Avi Singh explains How to Transform & Combine All Excel Sheets in Power BI (No Hardcoding)
- On the Power BI community blog, Parul Rani Sagar writes about Dynamic Change Tracking for LMS Enrolments Using Power Query M
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) describes how to Pivot - Get Data from Name Column Custom Field into Power BI using Power Query
- Chandeep Chhabra (@chandeep2786) talks about Small Power Query Habits That Change Everything
- Also on the Power BI community blog, Tharun Kumar Ravikrindhi explains how to Overcome Initial Full Load Failures in Power BI Incremental Refresh with Bootstrapped Load (2/2)
🧩 Data Modeling
- Chris Webb (@cwebb_bi) discusses Understanding The “Copilot Analyzed Only Part Of The Model Due To Its Size” Warning In Power BI Copilot
- Justin Martin (@dax_noob_justin) covers MCP Server: DAX Performance Tuner
- Parul Rani Sagar writes about Simplifying Reusable Logic in DAX with User-Defined Functions (UDFs)
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) talks about UDF (User Defined Function) in Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) blogs about Using VALUES in SUMMARIZE
- On the Power BI Tips YouTube channel, Mike Carlo and Tommy Puglia (@PowerBITips) talk about Measure Total Shenanigans - Ep.470 - Power BI tips
- Audrey Gerred covers The Star Schema Re-Visited Edition
📊 Report Authoring and Interactivity
- On the Power BI blog, Maya Shenhav (@MSPowerBI) announces Introducing Power BI Controller: Streamlining Storytelling with Bulk Operations (Preview)
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) explains how to Build Better Power BI Reports with New Card Visual
- Dane Belarmino showcases Power BI Report: Moments that Move the Earth
- On the SQLBI blog, Marco Russo (@marcorus) does a deep dive into Synoptic Panel to display tooth replacement in dental clinics
🚀 Deployment, Security and Operations
- On the Power BI community blog, Fatai Sanni discusses TMDL View in Power BI: The Game-Changer for Semantic Model Management
- Also on the Power BI community blog, Marcels Maglhaes describes Bringing Version Control to Power BI: A Gentle Introduction to Git and TMDL
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) walks through Enabling AI Copilot in Power BI License and Environment setup
- On the Power BI blog, Dustin Askins announces Power BI app Copilot: AI scoped to the curated content in an app (Preview)
- Also on the Power BI community blog, Ajay Babu Inturi writes about Power BI Workspace vs App: Build in One and Share from Another
- Also on the Power BI community blog, Gökberk Uzuntaş explains how to Automate Power BI Summary E-mails With Fabric Co-Pilot
- On the Power BI blog, Denyse Niwenshuti announces Deprecation Announcement: Office Online Server Retirement and What It Means for Power BI Report Server Users