Forum Discussion
Solved
Azure SQL DB bug in identifying the primary key for table?
Hi. We want to try Fabric with a mirrored MSSQL database, however we get this error for several tables: This table can't be mirrored to Fabric because the primary key column uses one of the follo...
Hi jozseftuska, we can confirm that this is a bug and in your scenario the table should NOT be blocked for Mirroring as you have a supported data type as a PK with a UK constraint of Date field. We'll work to have this bug resolved soon. Thanks for bringing this to our attention!
lbendlin
Super User
Super Usersure sounds like a design oversight. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .