Forum Discussion

DataPne's avatar
DataPne
Frequent Visitor
2 years ago

Gen2 Dataflow Error - MySql.Data.MySqlClient

Hi all,

Trying to access a MySql database via a dataflow but keep getting the same error:

"We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'"

 

For context, we are connecting via a gateway installed on an Azure (orchestrator) server. The MySql database is pingable and can be connected to via TablePlus. 

Anyone come across this before? Read some forums about downgrading the MySql driver - but seems like there could be something else going on.

Thanks a lot!! 🙂

Dataflows

2 Replies

  • miguel's avatar
    miguel
    Community Admin
    2 years ago

    What happens if you try to use a tool like Power BI Desktop inside of that VM to connect to your source? do you get the same issue?

    If yes, please reach out to the support team by creating a support ticket so an engineer can take a closer look:

    https://support.fabric.microsoft.com/support

  • DataPne's avatar
    DataPne
    Frequent Visitor
    2 years ago

    I ended up downgrading the MySql driver on the orchestrator and it worked fine!

    Thanks for the tip anyways 🙂