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.
  • In a trial capacity, you are limited to three databases. There is no limit on databases in other capacities.

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 most regions where Microsoft Fabric is available. For more information, see Fabric availability.

Note

To enable SQL database in Fabric, it must be available in both the home region of your tenant and the capacity region. If you don't have the option to enable SQL database in Fabric in your capacity, check the home region of the tenant to ensure SQL database is available in that region.

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

Limitations

For more limitations in specific areas, see:

Related content