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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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':"


Downloaded the client software, still same




The problem solved by download and installed the latest version of client software 'mysql-connector-net-6.6.7.msi' from the below link "". Now i can connect to my local MySql.

View solution in original post


this was it, thank you

at least in July 2023 with Windows 11


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

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?

New Member

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!



Frequent Visitor

Yes, I did.

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

Not applicable

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

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':

Já segui os passos da solução, porém não deu certo.

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 "". Now i can connect to my local MySql.

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?



installing the complete mysql package:

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors