Forum Discussion
Error UserErrorInvalidPluginType when copying data from on-prem SQL database to Fabric SQL
I'm trying to copy data from my on-prem BBDD to Fabric SQL using a data pipeline. However, I get this error when I try to do it:
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,'
Anyone know what's going on? Fabric SQL is so new that there isn't any info out there about this yet.
I have no idea what I should do.
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.
18 Replies
I faced the same issue while loading the data from On prem to Fabric SQL. -
Activity failed because an inner activity failed; Inner activity name: Copy_uns, 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,'
However, I was able to load data from On prem to Lakehouse.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&APlease Accept as solution if this meets your needs and a Kudos would be appreciated.
Regards,
Sahasra.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,
In my side, i have a another error with plugintype
https://community.fabric.microsoft.com/t5/Data-Pipeline/Error-Data-Pipeline-gt-Dynamics-Plugin-with-Dataverse-connector/m-p/4371176#M6889
Is there a link? I don't knowHi 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.
