Forum Discussion

Hemant_Patel's avatar
Hemant_Patel
Frequent Visitor
1 year ago
Solved

Copy data from on-premise database to Fabric SQL database

In Fabric data pipeline, I am trying to copy data from on-premise database to Fabric SQL database.   I am using service principal to authenticate with Fabric SQL database. I validated the authentic...
  • imrankhan0's avatar
    1 year ago

    It sounds like an issue with the linked service configuration. Have you checked if 'FabricSqlDatabase' is a supported type in your data pipeline setup? Also, ensure that all required permissions are granted to the service principal. Sometimes, revalidating the connection and updating the linked service type can resolve the issue. Hope this helps!