Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
Pipeline
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

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.