Microsoft Fabric Updates Blog

Simplifying file access in OPENROWSET using data sources and relative paths (Preview)

The introduction of data sources and relative paths in the OPENROWSET function unlocks a new level of simplicity and flexibility for querying files in your Lakehouse and beyond. By leveraging external data sources, you can write cleaner, more maintainable SQL queries and easily access data wherever it resides — making data engineering and analytics more … Continue reading “Simplifying file access in OPENROWSET using data sources and relative paths (Preview)”

Introducing Optimized Compaction in Fabric Spark

End Write Amplification and Automate Your Table Maintenance Compaction is one the most necessary but also challenging aspects of managing a Lakehouse architecture. Similar to file systems and even relational databases, unless closely managed, data will get fragmented over time, and can lead to excessive compute costs. The OPTIMIZE command exists to solve for this … Continue reading “Introducing Optimized Compaction in Fabric Spark”

Service Principal Support in Semantic Link: Enabling Scalable, Secure Automation

Microsoft Fabric continues to evolve as a unified platform for data professionals, and the latest update to Semantic Link introduces Service Principal support—a key enhancement for teams looking to automate and scale their data workflows securely.  Semantic Link enables seamless integration between notebooks and semantic models, allowing users to query and analyze data directly from … Continue reading “Service Principal Support in Semantic Link: Enabling Scalable, Secure Automation”

Mission-Critical Data Integration: What’s New in Fabric Data Factory

Why Mission-Critical Features Matter In the era of AI and cloud-scale analytics, organizations need a data integration platform that is secure, resilient, and ready for the most demanding workloads. Fabric Data Factory is engineered to deliver just that—enabling enterprises to unify, protect, and orchestrate their data across clouds, firewalls, and hybrid environments. Security, Isolation, and … Continue reading “Mission-Critical Data Integration: What’s New in Fabric Data Factory”

Introducing Fabric MCP (Preview)

The Model Context Protocol (MCP) for Fabric is a developer-focused framework that brings together Microsoft Fabric’s public APIs, item definitions, and best-practice guidance into a unified context layer designed for AI-assisted development. It runs locally on your machine, giving AI agents the context they need to generate code and author items without accessing your environment—keeping … Continue reading “Introducing Fabric MCP (Preview)”