Forum Discussion
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, but missing on this computer. To download client software for this provider, visit the following site and choose the 32-bit (x86) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885"
Downloaded the client software, still same
So......halp
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.
25 Replies
Hi Helger, I am also facing the same problem ! are you got any solution! somebody please help!!!:smileymad:
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.
I have the same issue but the link doesn't seem to work anymore.
Do you have any other way to get it?
Thanks!
Hi all,
thanks for the proposed solutions, but installing the following has still not solved the issue, I still get the error
Can it be there is a version conflict somewhere?
Strange thing is : on 1 laptop I got it working (but on this laptop I'm connecting to MySQL already for some time for other projects), on another one never got it working so far.
Anybody any idea where to look further?
Thanks a lot!
Levien
I get the error "We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'." and I can't find the x64 connector version to download. Does anyone know how to resolve this issue? I can't update my powerbi dashboards until this is resolved
Hello disskira i have the same issue too. May i ask how you were able to fix it?
Bom dia.. Estou com o mesmo problema, erro:
MySQL: Não conseguimos localizar um provedor de banco de dados com o nome invariável 'MySql.Data.MySqlClient'. Esse erro pode ter sido resultado da ausência de um software cliente específico do provedor necessário nesse computador. Para baixar o software cliente para esse provedor, visite o seguinte site e selecione a versão de 64 bits (x64), como mínimo, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885
Já segui os passos da solução, porém não deu certo.Yes, I did.
Could you please let me know what link you used, please?
Downgraded everything to 8.0.24 (server + connector) and it is fixed the problem.
this was it, thank you
at least in July 2023 with Windows 11
Hello Dear Community,
I'm struggling with a similiar error. My database is hosted on Amazon, and type of database is MySQL. The report is published to PowerBi service.
And on the desktop version of Power BI all is ok.
Please advise how to solve the issuer
managed to solve the issue by installing mysql-connector-net-8.0.28
