Forum Discussion
tables with a nonclustered primary key are not supported on Microsoft Fabric platform
I mirror data from an azure sql db to Fabric, but before azure sql db, we replicate data from an old db in a azure managed instance to azure sql db and then we mirror to Fabric. In the old db some ta...
Shahid12523
Community Champion
Community ChampionFabric doesn’t support nonclustered primary keys.
After you recreated replication, some tables in Azure SQL DB ended up with nonclustered PKs, so Fabric stopped syncing them — leaving data 1 day behind.
👉 Fix: Make sure PKs in Azure SQL DB are clustered before mirroring.