Azure sql managed instance mirror to Fabric - Error

Hi barcoyolo ,

Can you confirm if you have a public endpoint available to connect to your Managed Instance? The current preview does not support connecting to your Managed Instance via a private endpoint.

Having the same issue here, we do have a public endpoint setup and I can connect to the server from Dataflow Gen2, Power Query, or Notebooks, but mirroring won't work.

barcoyolo I'm not sure if you were able to get it to work, but I was finally able to after trying everything under the sun. To be more specific we tried everything until we changed the policy to be Always up to date, that made it work like magic.

1. Enable System Assigned Managed Identity

2. Updated the Policy for source Azure SQL Managed Instance configured to "Always up to date"

https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-managed-instance-tutorial

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql&preserve-view=true&tabs=azure-portal#always-up-to-date-update-policy