Fabric Weekly

Issue 10

15th September 2026

👋 Welcome to issue #10 of Fabric Weekly - It's a bumper one this time, covering two weeks, as I spent the past week up in the mountains with limited signal!

This week, on the official side:

From the community:

And, some events in the next couple of weeks:

  • Today, Tuesday 15 September, London - London Microsoft Fabric & Power BI - Erik Svensen on Visual Calculations in Power BI, now GA, from the basics through advanced use cases.
  • Thursday 17 September, Bristol - Fabric & Power BI Bristol - Victor Wingsing on catching data-leak risk with Purview Insider Risk Management and the new Fabric indicators, and Mathias Halkjær on "BI Buddy", his AI companion for Power BI.
  • Thursday 24 September, Manchester - PBIMCR - Leon Gordon on monitoring and governing Fabric at scale, and Vito Schittone on advancing your career in data.

🤖 Copilot, AI & Agents

📊 Reporting & Insights

⚙️ Data Engineering

  • Diagnose Fabric Data Warehouse workloads with the SQL DW operations skill (Generally Available) by Mariya Ali · 4 min read The SQL DW operations skill for Microsoft Fabric Data Warehouse is now generally available via the open-source Fabric skills repository. Using GitHub Copilot CLI, you can describe a warehouse problem in natural language and get bounded, read-only diagnostics — failed/canceled queries, capacity-spike correlation, resource-consuming query patterns, and custom SQL pool candidacy — with evidence and recommended actions.
  • From Business Events, Fabric Events, and Azure Events to Real-Time Hub by Roberto Cervantes · 1 min read This final post in the series demonstrates how to leverage Real-Time Hub to unify Business Events, Fabric Events, and Azure Events for seamless end-to-end analytics within Microsoft Fabric.
  • Is Data Engineering Dead Because of AI? by Aleksi Partanen Data engineering remains vital by focusing on understanding data architecture and platform governance, ensuring AI agents cannot access sensitive production data like HR records or financial information.
  • Event Schemas - Structure for Streaming Data by Matthias Falland Fabric's Event Schema Sets act as a contract layer for streaming pipelines, preventing silent data corruption when fields change. This walkthrough covers the four-layer entity model (Set → Type → Schema → Version), creating schemas via UI and code, enabling validation on Eventstream, and when the Fabric Schema Registry fits versus Confluent or Azure Event Hubs alternatives.
  • Advancing the Microsoft Fabric SQL Query Editor by Salil Kanade · 6 min read The updated Microsoft Fabric SQL Query Editor features faster data grids, an optimized object explorer, improved IntelliSense, and enhanced query management tools to streamline development workflows.
  • Sync Dataverse to Microsoft Fabric in Minutes by Alex Ward This tutorial shows how to quickly sync selected Dataverse tables to Microsoft Fabric for near real-time data access without exposing all data, perfect for Power Platform and Power BI users.
  • Fabric Apps Write-Back Dashboard Tutorial by Valerie Junk · 1 min read The Fabric Apps Write-Back Dashboard Tutorial guides beginners through building real-time reports using Fabric Real-Time Intelligence and KQL, even for those new to T-SQL.
  • Fabric Copy Job: Find the staging! by Reitse Eskens · 3 min read When a Fabric Copy Job against SQL Server via on-premises data gateway threw "Authentication failed because the remote party has closed the transport stream" on every table, the fix was enabling staging — but that checkbox isn't in the Copy Job GUI. The workaround: open View → Edit JSON and flip enableStaging from false to true.
  • Turn On Fabric Runtime 2.0 and You Can Lose Direct Lake by Aleksi Partanen Vesa Tikkanen warns that enabling Fabric Runtime 2.0 may disable Direct Lake functionality with certain Delta features, emphasizing the need for a GA gate to maintain compatibility.
  • Implementing SCD Type 2 in Microsoft Fabric – The Definitive Guide! by Nikola Ilic · 16 min read This guide shows how to implement SCD Type 2 in Microsoft Fabric to preserve full historical data by creating new records for each change while keeping old entries, crucial for accurate telecom customer analysis.
  • Fabric Data Warehouse best practices for medallion architectures by Sidney Cirqueira · 6 min read Fabric Data Warehouse's medallion architecture emphasizes operational discipline for predictable loads, repeatable transformations, and clear maintenance boundaries to avoid issues such as row-by-row loading and untestable Silver tables.
  • Spark Errors: The Answer Is Always There. On Page 60 of the Stack by Aleksi Partanen Vesa Tikkanen reveals that Spark error answers often reside in the stack trace, especially on page 60, and shares open-source diagnostic tools from a GitHub repo usable beyond Spark.
  • Using Spark SQL Temporary Views with Fabric Schema-enabled Lakehouses and High-Concurrency by Gerhard Brueckl · 3 min read When using notebookutils.notebook.runMultiple with schema-enabled Fabric lakehouses, SQL USE statements and non-unique temp view names break because notebooks share one Spark session. The fix: set a SparkSQL config property dynamically via PySpark to hold the full schema path, then reference it in temp views with ${property} syntax — works safely under runMultiple's parallel execution.
  • Microsoft Fabric SQL Analytics Endpoint Explained by Aleksi Partanen This video explains that each Lakehouse in Microsoft Fabric has a read-only SQL analytics endpoint, causing issues with data insertion or missing tables, and clarifies the differences between Spark writes and SQL reads.

🏛️ Storage & Platform

🔐 Governance & Security

💰 Management & Cost

📅 Community & Events

Get Fabric Weekly in your inbox every Tuesday

Sign up to receive the email every week and keep on top of all the announcements.

Don't forget to confirm your subscription. We have a double opt-in sign up process to prevent spam.

We will never provide your details to any third parties. We don't spam.

Fabric Weekly Logo