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,
Thanks for connecting with the Microsoft Fabric Community Forum.
The error message indicates that the type 'FabricSqlDatabase' is not recognized. This usually happens when the linked service type provided in the pipeline configuration does not match any registered or supported types.
Here's how you can resolve this issue:
- Ensure that the linked service type you are using is correct and supported. For Fabric SQL, the correct type might be different from 'FabricSqlDatabase'.
- Go to your data pipeline configuration and update the linked service type to the correct one. For example, if the correct type is 'AzureSqlDatabase', update your configuration accordingly.
- If updating the type doesn't resolve the issue, consider deleting and recreating the linked service with the correct type. This ensures that there are no leftover configuration issues.
I’m attaching the Microsoft document link, If you want you can go through it for your convenience
Link:
Copy and transform data to and from SQL Server - Azure Data Factory & Azure Synapse | Microsoft Learn
I’m also attaching the similar error solved solution for your reference please go through it once and clear your doubts
How to fix ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'GoogleBigQueryV2 Azure Data Factory - Microsoft Q&A
Please Accept as solution if this meets your needs and a Kudos would be appreciated.
Regards,
Sahasra.
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.