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

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi subashmahat ,

Thank you for reaching out to the Fabric Community. dlauth33 , has explained the key points very well.

If you’re using Mirroring with Azure SQL Managed Instance, you need to enable the  Always up to date update policy, as mentioned in the Microsoft documentation.

 

However, since you’re working with a Copy Activity, this setting isn’t required. As dlauth33,  rightly pointed out, it's important to check your network configurations, especially ensuring that traffic is allowed on the required ports.  If you’ve already allowed traffic but are still encountering issues, please let us know. We’re happy to help.

Thanks to dlauth33   for the valuable insights.

 

Helpful reference:Limitations in Mirrored Databases From Azure SQL Managed Instance (Preview) - Microsoft Fabric | Microsoft Learn

 

 

— Yugandhar
Community Support Team.