Fabric Data Warehouse Roadmap

by
Andrew Snodgrass

by
Andrew Snodgrass

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Update Oct. 2025 – FDW continues the slow march toward T-SQL compatibility and even released a migration tool, but the architectural differences with SQL Server show that refactoring is always required. AI is ever-present in the form of Copilot, and new security features help lock down where data can be sent, finally.

Fabric Data Warehouse (FDW), one of the main Fabric experiences, provides a SQL-based database solution where developers can create and manage traditional relational data warehouses to hold transactional data. They can build integration pipelines to ingest data, run scheduled and ad-hoc high-speed aggregations, and access the data warehouse through external applications and tools. As part of Fabric, FDW uses the same UI, workspaces, and data storage components as the other Fabric experiences, allowing it to participate in end-to-end workloads.

Product: Fabric Data Warehouse

Licensing: Fabric

Recent Updates and Near-Term Roadmap (2025–2026)

The near-term roadmap for FDW continues to focus on improving compatibility with SQL Server. Although the service is based on open-source technologies, and the data resides in a data lake, Microsoft is intent on the service becoming the replacement for Synapse Analytics SQL Dedicated pools. The challenge is that the older service is based on SQL Server, which is a mature, high-performance product developed over several decades, while FDW is relatively new.