Microsoft Fabric Updates Blog

What’s new in Fabric Warehouse – July 2025 Recap

Introduction Welcome to What’s New in Fabric Warehouse, where we’ll spotlight our work improving quality, delivering major performance enhancements, boosting developer productivity, and our continuous investments in security. Whether you’re migrating from Synapse, optimizing your workloads, writing SQL in VS Code, or exploring new APIs, this roundup has something for every data professional. With quality … Continue reading “What’s new in Fabric Warehouse – July 2025 Recap”

Streamlining Data Management with Workspace Collation Settings in Microsoft Fabric Warehouse and SQL Endpoint

Motherson, a global manufacturing specialist industry and one of the world’s leading automotive suppliers, faced significant challenges during their migration to Microsoft Fabric. They shared how the workspace collation settings transformed their experience: “As part of our migration from Microsoft SQL Server to Microsoft Fabric, we hit a major roadblock with the default case-sensitive collation … Continue reading “Streamlining Data Management with Workspace Collation Settings in Microsoft Fabric Warehouse and SQL Endpoint”

OneLake as a Source for COPY INTO and OPENROWSET (Preview)

Simplified, workspace-governed ingestion without external dependencies COPY INTO and OPENROWSET from OneLake are now available in Preview for Microsoft Fabric Data Warehouse. With this release, you can load and query files directly from Lakehouse File folders, without relying on external staging storage, SAS tokens, or complex IAM configurations. This improvement reinforces Fabric’s vision of a … Continue reading “OneLake as a Source for COPY INTO and OPENROWSET (Preview)”

Experience the New Visual SQL Audit Logs Configuration in Fabric Warehouse

In April, we announced the preview of SQL Audit Logs for Microsoft Fabric Data Warehouse, giving organizations the power to track and retain critical warehouse events for enhanced visibility and control. Today, we’re taking that experience to the next level. We’re introducing an all-new, intuitive visual experience—making it easier than ever to configure, enable, and … Continue reading “Experience the New Visual SQL Audit Logs Configuration in Fabric Warehouse”

Read JSON Lines files with OPENROWSET in Fabric Data Warehouse and Lakehouse SQL Analytics Endpoint

We’re happy to announce that now you can read JSON Lines (JSONL) using the OPENROWSET(BULK) function for Microsoft Fabric Data Warehouse and SQL Analytics Endpoints for Lakehouses. The OPENROWSET(BULK) function allows you to query external data stored in the lake using well-known T-SQL syntax. With this update, you can now also query files in JSON Lines format, expanding the range of supported formats and simplifying access … Continue reading “Read JSON Lines files with OPENROWSET in Fabric Data Warehouse and Lakehouse SQL Analytics Endpoint”