Fabric Weekly
1
17 Jun 2026 – 30 Jun 2026
🎉 Welcome to the very first edition of Fabric Weekly! After far too long leaving Microsoft Fabric to get covered as a footnote in everyone else's newsletter, it finally has one of its own. Every week from here on, we'll round up the official announcements, the community deep-dives, and the "wait, did you know Fabric could do that?" moments from across Data Engineering, Reporting & Insights, Storage & Platform, Governance & Security, Management & Cost, and Copilot/AI & Agents - all in one place.
On the official side:
The headline is Fabric Data Agents now supporting Microsoft Entra ID service principal authentication - one of the most requested capabilities for moving data agents from prototype to production, and the start of a short video series if you want to follow the setup step by step.
Also worth a look: Event-Driven Copy Job Execution with Fabric Activator is now GA, letting you trigger Copy jobs straight from an Activator rule with no pipeline in between, and there's a new Fabric Spark Operations Skill (Preview) that turns "why did my notebook fail at 3am" into a single natural-language prompt instead of a multi-tab log hunt.
Microsoft is also bringing Power Query connectors fully in-house with a clearer Preview-to-Retirement lifecycle.
And Build 2026 brought a long list of announcements covered in James Serra's roundup: Agent Skills for Power BI is the one most likely to change how you build reports, while Rayfin - the new open-source SDK that lets coding agents define and deploy a full governed app backend straight onto Fabric - might be the one that changes what counts as a Fabric workload at all.
Over in the community:
Roman Lánský dug into why your mirrored "real-time" reports might quietly be serving stale data, and what the new SQL endpoint metadata sync does about it.
Nikola has written the definitive (and very long) guide to variable libraries, the Fabric item that exists specifically so "Test is reading Prod" becomes a story you only tell at conferences.
John Kerski makes the case that DAX User Defined Functions are the biggest thing to happen to semantic model testing since PBIP, and has the downloads on his PQL.Assert library to back it up.
Meagan Longoria offers a sensible crawl-walk-run framework for agentic Power BI development if you'd rather not hand an AI agent the keys all at once
And, Adam Marczak argues it's time to stop treating Azure itself as the platform and pick Fabric or Databricks as the actual center instead.
Thanks for being here for issue #1 - tell a friend, tell your whole workspace...
🤖 Copilot, AI & Agents
- Power BI Copilot, Data Agent Optimization & Performance Power BI Copilot and Data Agent optimizations aim to enhance performance while exploring whether agentic analytics will complement rather than replace traditional dashboard reporting for most business users.
- Crawl, Walk, Run with Agentic Development of Power BI Assets This guide introduces a phased approach to integrating generative AI into Power BI development-starting with simple chat queries, progressing to code assistance via extensions, then automating report generation, and finally building full agentic workflows that manage data pipelines end-to-end while addressing ethical and compliance considerations.
- Data Agents - Service Principal Support Fabric Data Agents now support Microsoft Entra ID service principal authentication, letting production apps and Microsoft Foundry agents call a data agent's API with an application identity instead of a delegated user login \u2014 a top customer request for moving data agents from prototype to production. This is the first in a short video series from Power Mates that walks through the setup end-to-end.
- Monitoring weather conditions in real-time using AI and Fabric Eventstream Using natural-language prompts with Fabric Eventstream and Eventhouse AI Skills, the team stood up a real-time heat-stress monitoring pipeline across all 11 US World Cup host cities in under four minutes \u2014 work that would normally take an hour or more of manual portal configuration.
- Microsoft Build 2026 announcements James Serra's roundup of Microsoft Build 2026 data/AI announcements, including Agent Skills for Power BI (AI-assisted semantic model and report authoring), Fabric Apps for building custom web apps on governed Power BI models, open-source Skills for Fabric for AI coding assistants, a GPU-accelerated Fabric Data Warehouse preview, and Graph in Fabric reaching general availability \u2014 plus a long tail of Real-Time Intelligence, governance, and storage updates.
📊 Reporting & Insights
- Using REMOVEFILTERS in DAX user-defined functions This article shows how to create a DAX UDF using REMOVEFILTERS to clear filter-keep column filters on a calendar table for precise running total…
- New Book: “Extreme DAX” 2nd Edition The 2nd edition of “Extreme DAX” by Michiel Rozema, Madzy Stikkelorum, and Henk Vlootman deepens coverage with advanced techniques like Auto-Exist, making it valuable for Power BI developers tackling complex real-life problems.
- Speaking @ PBIG Evening session @ Wortell Valerie Junk showcased "Matrix Visuals" techniques at the Power BI Gebruikergsgroep event in Wortell, highlighting innovative ways to master complex data presentations.
- Why User Defined Functions (UDFs) Changed Testing in Power BI DAX User Defined Functions finally let testing logic live inside the semantic model itself instead of in external scripts and pipelines. The author built PQL.Assert, a reusable assertion library for Power BI semantic models powered by UDFs, which has already passed 1,800 downloads since its February 2026 launch.
- Attending a Level 400 training at Microsoft. A first-hand account of a Microsoft Level 400 partner training on Real-Time Intelligence in London, covering Fabric RTI data ingestion, Eventhouse processing with KQL, row-level security on Eventhouse, and Activator's trigger interval dropping from 5 minutes down to 5 seconds \u2014 plus CI/CD and the Fabric RTI MCP server.
- Microsoft Reactor: PBI Dataviz World Championship Kick off The Power BI DataViz World Championship, kicking off at Microsoft Reactor, showcases exceptional data visualization talent and innovative techniques worth examining.
- The Most Important DAX Concepts to Learn First This article breaks down four essential DAX concepts-filter context, relationships, grain, and context transition-with clear examples to help beginners avoid common calculation errors in Power BI.
⚙️ Data Engineering
- Introducing the Fabric Data Warehouse CLI and MCP Server The Fabric Data Warehouse CLI and MCP Server simplify management of data warehouse and SQL endpoints for data professionals.
- Fabric for Operational Reporting & SQL Endpoint Trap Mirroring data into Fabric for live operational reporting sounds simple, but real-world data needs transformation, pushing teams to a Lakehouse + SQL endpoint + Direct Query design that's exposed to unpredictable SQL endpoint lag. A new metadata sync, in preview since May 2026, adds on-demand refresh-on-read and measurably reduces that lag for newly created endpoints.
- Improve performance for Python UDFs and complex data types in Microsoft Fabric’s Native Execution Engine Microsoft Fabric's Native Execution Engine speeds up Python/Scala UDFs and complex data types (arrays, maps, structs) with no code changes required — internal benchmarks show up to 5.76\u00D7 faster vectorized UDFs and up to 2.35\u00D7 faster end-to-end workloads.
- Event-Driven Copy Job Execution with Fabric Activator (Generally Available) Fabric Activator’s new feature lets you trigger copy jobs directly in response to real-time events, eliminating unnecessary data movement and reducing operational overhead by enabling event-driven data pipelines without extra orchestration.
- New string functions and operators in Fabric Data Warehouse (Preview) Fabric Data Warehouse’s preview introduces approximate string matching tools and enhanced T-SQL string functions, streamlining complex text operations in SQL queries.
- Simplify Spark failure diagnosis in Fabric (Preview) The new Fabric Spark Operations Skill lets you describe a Spark issue in plain English and get back an AI-generated, severity-ranked diagnostic report \u2014 covering failed notebooks, pipeline failures, and workspace-wide health \u2014 without manually cross-referencing the Spark Monitor, logs, and Spark Advisor.
🏛️ Storage & Platform
- The evolution of Azure Data Platforms, and the future with Databricks- and Fabric-centric architectures Argues that organizations should stop treating Azure itself as the data platform and instead pick Databricks or Fabric as the actual center, with Azure relegated to a transparent backbone \u2014 similar to how Snowflake treats its underlying cloud. That mindset shift changes concrete decisions, like whether users need direct access to the data lake or Key Vault at all, versus going through Unity Catalog or Fabric's own governance layer.
- ServiceNow Zero-Copy Querying of Enterprise Data in Microsoft OneLake (Preview) The new ServiceNow connector for Microsoft OneLake enables direct access to enterprise data without copying, offering lower complexity, consistent governance, and richer workflow context across incident management, field service, supply chain, and AI-powered experiences.
🔐 Governance & Security
- On-premises data gateway June 2026 release June 2026's on-premises data gateway (v3000.322) adds Windows Web Account Manager authentication for stronger token security, patches the bundled Apache Log4j library to 2.25.4, and introduces consent-driven diagnostic uploads surfaced directly in the Dataflow Gen2 run experience \u2014 alongside compatibility with this month's Power BI Desktop release.
- Securing the Power Query connector ecosystem in Fabric Microsoft is bringing Power Query connectors fully in-house and formalizing a clear lifecycle (Preview \u2192 GA \u2192 Transparent Migration \u2192 Retirement) to tighten security and predictability across the connector supply chain. Recent Microsoft-owned V2 connectors reaching GA include Snowflake, Google BigQuery, and Amazon Redshift.
💰 Management & Cost
- Use Managed DevOps Pools for Microsoft Fabric deployments Managed DevOps Pools in Azure streamline deployments by securely integrating with firewall-protected Azure Key Vaults, reducing complexity and…
- Fabric Jumpstart End to end Tutorial with Fabric Capacity Events Fabric Jumpstart shows how to deploy a Real-Time Intelligence workload with Capacity Events for real-time fabric capacity monitoring and proactive…
- Want to look at cloud reporting but not sure what the costs will be? A consultant's real-world cost breakdown for Fabric/Snowflake-based reporting solutions \u2014 some clients pay under \u00A3100/month total. The key levers: only run capacity when needed (auto-pause/resume via GitHub Actions for Fabric, since unlike Snowflake it doesn't suspend itself), start at the smallest capacity (F2 for Fabric), and avoid retaining or modeling data you don't need.
- Variable libraries in Microsoft Fabric: One value to rule them all! Variable libraries in Microsoft Fabric centralize configuration management, allowing single-source changes for environment customization and cross-item reuse, reducing errors like misdirected data pipelines across development, testing, and production stages.
- Seamlessly Moving Fabric Notebooks Across Workspaces with Lakehouse Auto-Binding and Git Integration The new Lakehouse Auto-Binding feature in Fabric’s Notebook Git integration automatically maintains notebook-Lakehouse relationships when moving notebooks across workspaces, streamlining multi-environment development and CI/CD processes.