Limitations of Fabric Data Warehouse

Applies to: ✅ SQL analytics endpoint and Warehouse in Microsoft Fabric

This article lists current limitations for warehouse and SQL analytics endpoint items in Microsoft Fabric. For limitations of SQL database in Fabric, see Limitations in SQL database in Microsoft Fabric (preview).

Limitations

This article lists current general product limitations for data warehousing in Microsoft Fabric. Feature level limitations are called out in the corresponding feature article. For more information on the future of Microsoft Fabric, see Fabric Roadmap.

T-SQL syntax support

Fabric Data Warehouse doesn't support every Transact-SQL statement available in SQL Server.

Cross-region connections aren't supported

Fabric Data Warehouse and SQL analytics endpoint connections require both the source and target items to be in the same region. Cross-region connections - including those across workspaces or capacities in different regions - aren't supported and might fail to authenticate or connect.

Feature-specific Fabric Data Warehouse limitations

For limitations in specific features of Fabric Data Warehouse and the SQL analytics endpoint, see:

• Clone table limitations
• Configurable data retention limitations
• Connectivity considerations and limitations
• Data types in Microsoft Fabric
• Delta Lake logs limitations
• Migration Assistant limitations
• Pause and resume considerations and limitations
• Semantic models limitations
• Share your data and manage permissions limitations
• Source control limitations
• SQL analytics endpoint limitations
• Statistics limitations
• Tables limitations
• Transactions limitations
• Visual query editor limitations

Known issues

For known issues in Microsoft Fabric, visit Microsoft Fabric Known Issues.

Related content

• T-SQL surface area in Fabric Data Warehouse
• Create a Warehouse in Microsoft Fabric