Forum Discussion
Solved
Getting data/ mirroring from SQL Managed Instance to Fabrics
Hello I am trying to get data through a copy activity from Azure SQL Managed instance in Fabrics However everytime i try to do this i am face with this error: An exception occurred: DataSourc...
I'm pretty sure I used the gateway ip's for power bi and not servicefabric. Try that. ServiceFabric is not the same product as Fabric which is pretty confusing. I didn't remember there being an entry in the IP Gateway for only "Fabric".
Here's a link to the prerequisites:
https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-managed-instance-tutorial
Always up to date is a requirement to mirror a managed instance. There are also some changes to be made to the SAMI on the source SQL managed instance.
I did go through this. Is there a way that I could use copy activity directly with managed instance.