Gen2 Dataflow Error - MySql.Data.MySqlClient

[DataPne]

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!! 🙂

[DataPne]

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

Thanks for the tip anyways 🙂

[miguel]

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