Edit

Share via

Limitations in SQL database in Microsoft Fabric (preview)

  • Article

Applies to: ✅ SQL database in Microsoft Fabric

Current limitations in the SQL database in Fabric are listed in this page. This page is subject to change.

These limitations apply to SQL database in Fabric only. For the warehouse and SQL analytics endpoint items in Fabric Data Warehouse, see Limitations of Fabric Data Warehouse.

Important

This feature is in preview.

Database level limitations

  • SQL database in Fabric does not support Change Data Capture (CDC) or Azure Synapse Link for SQL.
  • SQL Audit is not currently supported in SQL database in Fabric.
  • Transparent Data Encryption (TDE) is not supported. SQL database in Fabric uses storage encryption with service-managed keys to protect all customer data at rest. Customer-managed keys are not supported.

Table level

  • A table primary key cannot be one of these data types: hierarchyid, sql_variant, timestamp.
  • If one or more columns in the table is of type Large Binary Object (LOB) with a size > 1 MB, the column data is truncated to size of 1 MB in Fabric OneLake.
  • Currently, tables cannot be in-memory tables.
  • Full-text indexing is not supported and cannot be created in SQL database in Microsoft Fabric.
  • The following table-level data definition language (DDL) operations aren't allowed:
    • Switch/Split/Merge partition
    • Partition compression

Column level

  • Column names for a SQL table cannot contain spaces nor the following characters: , ; { } ( ) \n \t =.

SQL analytics endpoint limitations 

Availability

SQL database in Fabric is available in regions where Microsoft Fabric is available. For more information, see Fabric availability.

Mirroring of SQL database in Fabric is available in Fabric regions that support mirroring.

Currently, Fabric SQL database is not available if you had Private link enabled on your Fabric tenant at the start of the preview on November 19.

Limitations

For more limitations in specific areas, see:

Related content