Power BI Weekly
Issue 368
28th July 2026
We have received the Power BI July 2026 Feature Summary. The highlights for me are the TMDL view on the web, conditional formatting finally extending to line charts and legends, and a small but welcome addition to let you write measure descriptions via triple-slash comments right where you define the measure. Organisational apps also gain GA support for audiences, so different user groups can get tailored views of the same app. Something operational worth flagging: if you're on a Power BI Desktop build from March 2026 or earlier, you'll lose the ability to save and share files to OneDrive and SharePoint from October. Make sure you update to keep saving to OneDrive/SharePoint!
Elsewhere this week, Chris Webb has written about why DAX UDFs matter more now that M365 Copilot queries semantic models directly rather than building Power BI visuals. Wrapping measure logic in a well-documented UDF, and telling Copilot in the metadata to always use it, is a neat way of keeping some governance and predictability over LLM results.
On the governance and security side, Meagan Longoria has a timely warning about Fabric's inbound network protection settings. Flipping on Private Link or Block Public Internet Access quietly breaks a number of things (on-premises gateways, mirroring for older SQL Server versions, Purview scanning, Copilot, even PDF exports in some cases) which aren't particularly well documented. Make sure you read Meagan's blog if you're considering enabling this feature!
On a separate note, Jason Cockington has a nice piece on the hidden cost of VertiPaq scans, showing how two DAX measures that return identical results can have very different Storage Engine footprints. Finally, John Kerski has published a reflective piece on five years of bringing DataOps to Power BI and Fabric. Worth a read if you're thinking about how DataOps practices should evolve as more of your estate moves into Fabric.
Data Prep
- How to Export Jira Data to Power BI: A Step-by-Step Guide for Every Team This guide details four methods for exporting Jira data to Power BI, from simple CSV exports to using Atlassian’s native connector apps, each with varying ease and technical requirements.
Data Modeling
- Analyzing the performance impact of visual calculations Visual calculations can significantly improve report performance by reusing precomputed values from virtual tables, reducing a 13-second DAX measure to under 6 seconds.
- Power BI, M365 Copilot And The Importance Of DAX UDFs M365 Copilot now requires a Premium license while removing Fabric capacity needs, improving DAX UDFs for better query performance and consistency.
- How to Change a Measure in Power BI SAFELY This Power BI video shows how to safely change a core measure by identifying all dependencies, using tools like Fabric Copilot, and preserving business logic through best practices such as renaming measures and updating documentation.
- The Hidden Cost of VertiPaq Scans The Hidden Cost of VertiPaq Scans shows that identical DAX measures can have significant performance differences affecting report efficiency unnoticed.
- DAX Performance Tuner MCP Server The DAX Performance Tuner MCP Server optimizes the Daxlib.SVG.Compound.Violin() function by reducing query execution time by up to 40% through intelligent caching and parallel processing.
- Simplify Power BI DAX with Visual Calculations Visual calculations in Power BI simplify writing complex DAX functions directly within visuals, often improving performance by working on aggregated data.
- Training Staff on Agents for DAX - Ep.549 - Power BI tips Discussing the debate as to whether junior analysts need foundational DAX skills before leveraging AI agents to prevent dangerous technical blind spots.
- ChatGPT + Power BI: medidas DAX con Time Intelligence usando MCP [Spanish] This tutorial shows how to use ChatGPT and Power BI’s MCP to translate names, create a DAX calendar table with best practices, and calculate Time Intelligence measures like previous month sales and year-to-date totals using DATEADD and DATESYTD in Power BI Desktop.
- Teach Claude & AI Your Power BI Standards — Custom Skills for the Power BI Modeling MCP Server This video shows how to create a custom skill file for Claude AI to generate Power BI models following your specified naming conventions, measure structures, display folders, and documentation rules using the Power BI Modeling MCP Server.
Report Authoring and Interactivity
- SVG Rendering Cost in Power BI Power BI’s new analysis reveals that SVG rendering cost is primarily driven by image complexity and data refresh frequency, impacting dashboard responsiveness.
- Power BI Line Charts Just Got a Major Upgrade [Conditional Line Color] The July 2026 Power BI update introduces conditional line color settings and gradient support, enabling more dynamic data visualization directly within reports.
- 5 Power BI Slicer Tricks To Build Professional Dashboards Discover five advanced Power BI slicer techniques-automatic month selection after refreshes, Apply All/Clear All buttons, Field Parameters for dynamic column display, highlighting data instead of filtering with slicers, and creating hierarchies for measures-that enhance dashboard interactivity and usability.
- Personaliza Power BI: todo lo que necesitas saber de actualización de Microsoft [Spanish] The July 2026 Power BI update introduces a new customization theme panel and conditional formatting for line charts, allowing users to dynamically change line colors based on defined rules.
Deployment, Security and Operations
- Think Twice Before Enabling Fabric’s Inbound Network Protection Enabling Fabric’s inbound network protection can degrade or disable critical features like on-premises data gateways, mirroring for older SQL Server versions, pipelines interacting with Data Warehouses, Eventhouse real-time analytics, Purview governance scanning, and Power BI sensitivity labels without clear documentation.
- Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports This updated guide explains that Power BI performance results from various factors including data source, storage mode, semantic model, and refresh processes, emphasizing the need to evaluate each layer for diagnosing bottlenecks.
- The PBIP format in simple terms: why metadata is so important The PBIP format enhances Power BI scalability and collaboration by enabling source control, automated testing, and agentic development while offering productivity gains over the binary PBIX file.
- Fabric-CICD Updates - Semantic Models, Parameters and Config Fabric-CICD’s latest update introduces semantic model binding and enhanced YAML configuration for more precise CI/CD workflows.
- Dynamic Data Masking in Power BI Power BI now offers secure dynamic data masking for import models, allowing sensitive information to be hidden in real time based on user roles.
- Obsidian + OKF + PBIP: Turn Power BI documentation into reusable knowledge - Part 2 This video shows how to convert Power BI docs into reusable knowledge using Obsidian, OKF, and PBIP with tools like structured gap checks, YAML frontmatter, and semantic models.
- Power BI Export to Excel has no name or underscores! Fix! Power BI generates unreadable filenames during Excel exports because of specific formatting settings that trigger character limits, but adjusting settings in the Format pane resolves the issue.
- Five Years of Bringing DataOps to Power BI and Fabric Over five years, DataOps has expanded from Power BI to Fabric, reducing cycle times with project files and AI tools, improving reusability via UDFs and DAX Query View, and enhancing model quality through automated testing.
- Power Bi Alerts with DAX in Power Automate This article shows how to use Power Automate with DAX queries to automate email or Teams notifications for real-time monitoring of multiple key metrics in Power BI.
- How to Get Report and Dataset Count in Power BI Workspace | REST API & PowerShell Power BI REST API endpoints combined with PowerShell scripts allow administrators to automate workspace inventory audits and track asset growth.
General
- Power BI July 2026 Feature Summary Power BI July 2026 adds expanded visual defaults, improved conditional formatting for line charts and legends, new organizational app features, and updated model options to enhance reporting and collaboration.
- The future of conversational analytics in Fabric Fabric is integrating conversational analytics across Fabric IQ, Power BI, Microsoft 365 Copilot, and custom data agents to enable natural language queries on business data for actionable insights.
- Excel or Power BI: Why Start Over? Your Excel skills in data cleaning with Power Query and Pivot Tables translate easily to mastering Power BI, cutting transition time and enhancing reporting efficiency.