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.
Hello, Can you please respond to my message?
Hi Anonymous,
We sincerely apologize for the inconvenience.
We are currently looking into the issue, and we will update you as soon as possible.
Thank you for your patience.
Hello, thank you. Do you have any updates? I believe this is related with the connection to my Fabric SQL Database. The connection type is "Fabric SQL database". However, the error message says it needs to be "FabricSQLdatabase" (no spaces). I can't change the type however as it's chosen by Power BI Service.
What can I do?
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?