topic Re: Gen2 Dataflow Error - MySql.Data.MySqlClient in Dataflow

Gen2 Dataflow Error - MySql.Data.MySqlClient

DataPne — Thu, 24 Aug 2023 12:19:12 GMT

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

Re: Gen2 Dataflow Error - MySql.Data.MySqlClient

miguel — Thu, 24 Aug 2023 16:11:19 GMT

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

Re: Gen2 Dataflow Error - MySql.Data.MySqlClient

DataPne — Fri, 25 Aug 2023 12:01:33 GMT

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

Thanks for the tip anyways 🙂