Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

23 REPLIES 23
Syndicate_Admin
Administrator
Administrator

this was it, thank you

at least in July 2023 with Windows 11

Syndicate_Admin
Administrator
Administrator

Downgraded everything to 8.0.24 (server + connector) and it is fixed the problem. 

disskira
New Member

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?

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.

onifemi
Frequent Visitor

This error seems to start showing up after upgrade of the connector to 8.0.33,
How do I downgrade back to the previous version please???

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. 

We cannot downgrade from 8.0.33 because the lower version is vulnerable to log4j.  There as got to be real fix out there.

Hello @onifemi ,

May I ask which version did you use? Also should the.  Mysql connector net and workbench have the. Same versions? Thanks

I'm having the same error but I don't see how to downgrade the version. How were you able to downgrade? I don't see that option. Did you uninstall and then find an older version to install? Thanks!

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/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors