Mirrored Database source connection error

[Melikag]

Hi,

I have created a Mirrored database in Fabric that is mirroring Snowflake which was working fine. Since we changed the workspaces capacity from P1 to Fabric F64 the mirrored database has stopped working and it seems like no source connection is being found. But the issue is that there is no option available in the configuration to modify the source connection or even create a new one.

[Anonymous · Accepted solution]

Hi @Melikag 

As you have tried all the workarounds mentioned but are still encountering the issue, I suggest raising a support ticket. To create a support ticket for Fabric and Power BI, please refer to the steps outlined in the following guide:

How to create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

If this helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[Melikag]

Hi @Anonymous ,

Thank you, I have already submitted a support ticket, been more than a week and still no response!

It seems like even the support team don't know how to solve the issue.

[Anonymous]

Hi @Melikag 
Sorry for the inconvenience. The Microsoft support team is looking into it. They will resolve the issue as soon as possible. Thank you for your patience and understanding.

[Melikag]

Thank you @Anonymous, the gateway and connection has the required credentials and are online. Firewall and whitelisting has been checked. User has all the snowflake permissions. But the issue is the Mirroring configuration doesn't let me modify anthing.
I know that data is being updating everyday but the replication is not resumed.

[Anonymous]

Hi @Melikag 
Thank you for reaching out microsoft fabric community forum.
If your Mirrored Database in Microsoft Fabric stopped working after changing the workspace capacity from P1 to Fabric F64, it may have lost its source connection. Verify the Snowflake connection settings in Settings → Manage Connection and Gateways and revalidate credentials if needed. Ensure any firewall or IP whitelisting is updated for the new Fabric capacity. Check the Mirroring Configuration to confirm data selection and restart the replication process if necessary. Monitor the status in “Monitor Replication” and ensure the Snowflake user has the required CREATE STREAM, SELECT, SHOW, and DESCRIBE permissions. If no updates occur, replication may pause temporarily and resume automatically when new data is detected.

If you need more info please go through below microsoft official documentation. It might helps you.
 Mirroring - Microsoft Fabric | Microsoft Learn
 Tutorial: Configure a Microsoft Fabric Mirrored Database From Snowflake - Microsoft Fabric | Microso...

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.