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.
Just restart your on-premises data gateway (personal mode). It should work. It did for me.