Forum Discussion
Unable to find a database provider
I've read up on how to address the "We were unable to find a database provider with the invariant name "MySQL.Data.MySQL Client". I've downloaded and installed the required MySQL Connector, and sti...
It seems like a common problem. I have the exact issue now. I can connect to MySQL DB from PowerBI Desktop on my local system. But as soon as I published the report and tried to refresh the data, it failed with the same error. Unable to find the solution yet. This is painful as reports do not get updated data and fail to make decisions.
You have to also run the older version of the mysql .net connector on your power bi enterprise data gateway also if you want published data refreshes to work as well. On my desktop and enterprise data gateway I run 8.0.28. My tests using newer .29, .30, .33 on desktop and enterprise data gateway all fail.