Forum Discussion
Error UserErrorInvalidPluginType when copying data from on-prem SQL database to Fabric SQL
Hi Anonymous,
The error message you're encountering -- UserErrorInvalidPluginType suggests that the linked service type FabricSqlDatabase may not yet be supported or correctly registered in the data pipeline environment you're using. Since Fabric SQL is still evolving and this type of integration might require backend validation or updates, this scenario may need deeper investigation by the product engineering team.
To proceed, I recommend you raising a support ticket with Microsoft so the relevant team can review your environment and configuration in detail.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
In the meantime, please ensure you're using the most recent connectors and document your pipeline configuration while submitting the ticket to help the support team triage the issue efficiently.
Thakn you and continue using Microsoft Fabric Commuity Forum.
Hi Anonymous,
As per your issue we successfully connected from onprem Database to fabric SQL using pipeline.
Here in Microsoft fabric, we created fabric SQL database, getdata-newdatapipeline.
Then we give the source,
Go to SQL server database in that give server name, connection type credentials and make
sure enable the gateway (provide server name which we take from on Prem database).
After that in destination provide the fabric SQL you created.
Then we can achieve the successful run pipeline, and data will be copied in fabric SQL, here is the snapshot.
Hope this suggestion gives you an idea to copy data from on Prem. If you have any further assistance, feel free to let us know.
Please Accept as solution If this post clears your issue and a Kudos would be appreciated.
Rgards,
Sahasra.
can you please show me how your Fabric SQL connection is configured?