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".
you mentioned in your first comment that you didn't have "always up to date" turned on. That's a requirement for mirroring a managed instance. If you just want to use a copy activity you just just need to turn on the public endpoint and whitelist the ip gateways for Fabric for your region in the network security group setting...allowing traffic to port 3342 (which the public endpoint uses)
I whitelisted the ip with servicetag servicefabric. it still does not allow me to connect to azure managed instance