cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
helger
New Member

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

1 ACCEPTED SOLUTION

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.

View solution in original post

14 REPLIES 14
leviendeh
New Member

Hi all,

 

thanks for the proposed solutions, but installing the following has still not solved the issue, I still get the error

leviendeh_0-1663753095235.png

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

swaroopjk
Frequent Visitor

Yes, I did.

Could you please let me know what link you used, please?

Anonymous
Not applicable

Just restart your on-premises data gateway (personal mode). It should work. It did for me.

Ualas
Helper I
Helper I

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.

om
New Member

Hi Helger, I am also facing the same problem ! are you got any solution! somebody please help!!!Smiley Mad

 

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!

installing the complete mysql package:

 

https://dev.mysql.com/downloads/windows/installer/

The install is for 32 bit, i need it for 64 bit, any references?

 

swaroopjk_1-1626877730963.png

 

same problem...  could anybody help? 

Did you find the 64 bit connector

Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors