Forum Discussion
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...
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!
Hello Hemant_Patel
For copying data to a Fabric SQL database, you may need to use `AzureSQLDatabase` linked service type.
please give it a try.