Forum Discussion
Solved
Power BI Desktop - Unable to Connect
Details: "MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. <br>This error could've been the result of provider-specific client software being required,...
The problem solved by download and installed the latest version of client software 'mysql-connector-net-6.6.7.msi' from the below link "http://dev.mysql.com/downloads/connector/net/6.6.html". Now i can connect to my local MySql.
This is to confirm that DOWNGRADING from 8.0.33 version of NET connector using the Mysql installer fixed the problem.
Y'all should try downgrading too.
Hello onifemi ,
May I ask which version did you use? Also should the. Mysql connector net and workbench have the. Same versions? Thanks