Forum Discussion

subashmahat's avatar
subashmahat
Frequent Visitor
1 year ago
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...
capacities
CICD
Data hub
one lake
workspaces
  • dlauth33's avatar
    dlauth33
    1 year ago

    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".

subashmahat's avatar
subashmahat
Frequent Visitor
1 year ago

I whitelisted the ip with servicetag servicefabric. it still does not allow me to connect to azure managed instance

dlauth33's avatar
dlauth33
Frequent Visitor
1 year ago

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".

  • subashmahat's avatar
    subashmahat
    Frequent Visitor
    1 year ago

    I allowed the power bi ip addresses in the NSG, it had not worked. Then i found there were additional IP the NSG was still blocking. Once those were removed from the blocked list. I was able to connect to managed instance. 


    Mirroring will require me to change the update policy. Thank you for the help.