Error UserErrorInvalidPluginType when copying data from on-prem SQL database to Fabric SQL

[blackflag]

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.

[v-sgandrathi · Accepted solution]

Hi @blackflag,

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.

[vivien57]

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-...

Is there a link? I don't know

[karthikvalluri]

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. 

[blackflag]

Hi Sahasra, your response seems to be generated by AI. Can you please personally help me? You're giving me links to Data Factory in Azure, but my problem is in Fabric

[v-sgandrathi]

Hi @blackflag,

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 Lear...
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.PluginNot...

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

Regards,
Sahasra.

[blackflag]

Hello, Can you please respond to my message? 

[v-sgandrathi]

Hi @blackflag,

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.

[blackflag]

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? 

[v-sgandrathi]

Hi @blackflag,

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.

[blackflag]

also, can you please help me solve the error I had at the begininng? 

[blackflag]

can you please show me how your Fabric SQL connection is configured? 

[v-sgandrathi]

Hi @blackflag ,

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.

[v-sgandrathi]

Hi @blackflag,

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.

[v-sgandrathi]

Hi @blackflag,

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.

[v-sgandrathi]

Hi @blackflag,

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.

[blackflag]

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,'

[v-sgandrathi]

Hi @blackflag,

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.

[v-sgandrathi]

Hi @blackflag,

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.