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 ,
Here is the Fabric SQL connection steps
In SQL Database, we created a pipeline. Then in source settings select SQL Server database which is onprem.
We have sample data in SQL server, click connect then will see the info as below
Give the server name in connection settings in fabric here enable the gateway connection , check the authentication type and give your username password as per above snapshot.
Then select the data you want to import and click Next.
Copy data from SQL server to Sql Database.
Then run the pipeline.
Run was successful and Data is reflected in the Database we created.
To avoid potential issues, try performing the steps in a completely new workspace and verify the results.
Thankyou.
Hi Anonymous,
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
Thankyou.
Hi Anonymous,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you for being a part of the Microsoft Fabric Community.
Hi Anonymous,
I wanted to follow up on our previous suggestions regarding Error. We would love to hear back from you to ensure we can assist you further.If my response has addressed your query, please accept it as a solution and give a Kudos so other members can easily find it.
Thank you for being a part of the Microsoft Fabric Community.
nope, still doesn't work. im getting the error:
ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'FabricSqlDatabase' is provided in 'linkedServices'. Please correct the type in payload and retry.,Source=Microsoft.DataTransfer.ClientLibrary,'
Hi Anonymous,
Since you are still encountering the same issue after following the steps, could you please share the steps you have taken and a screenshot of the error message? This will help us understand the situation better.
Thankyou.
Hi Anonymous,
I wanted to check and see if you had a chance to review my previous message or Please let me know if everything is sorted or if you need any further assistance.
Thankyou.