Azure SQL Database Fabric Mirroring not working using REST API

Hi AyusmanBasu0604,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Thomaslleblanc, for his inputs on this thread.

You have done everything right on the permissions and setup side the “missing tables” issue isn’t because of your code or identity. The REST API just doesn’t yet support registering tables directly during the create call for Azure SQL DB.

The fix is: Either register the tables afterwards (via UI or via the /tables API endpoint). Or wait until Microsoft brings feature parity between UI and REST (since table registration is a preview limitation right now).

So, to resolve your case right now: Update your workflow to first create the mirrored DB (like you already do), and then use the /tables endpoint to register your Azure SQL DB tables. That way, you will see the tables appear just like in the Fabric UI.

Kindly refer these links:
Fabric Mirroring Public REST API - Microsoft Fabric | Microsoft Learn
Troubleshoot mirroring from Fabric SQL database - Microsoft Fabric | Microsoft Learn

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

Hi AyusmanBasu0604,

Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

Thank you.