MySQL Connector Not Working

[daverothwell]

Hi All,

I'm having a very similar issue to what was detailed here https://community.powerbi.com/t5/Desktop/Cannot-connect-to-local-MySQL-database/m-p/206937#M91169 

Only that was 5 years ago with much older versions of everything.

I'm trying to get setup on a new machine and am unable to initiate a conneciton to MySQL.

Power BI Desktop: Version: 2.104.941.0 64-bit (April 2022)

I've installed:

mysql-connector-net-8.0.29.msi   (seems there's only a 32bit version available for this)

mysql-connector-odbc-8.0.29-winx64.msi

mysql-connector-odbc-8.0.29-win32.msi

and keep getting the error below when trying to add a MySQL data source (before even entering any specific server info):

I have MySQL Workbench and am able to connect to my target server with no issue. I tried uninstalling the 64bit version of the desktop app and using 32bit instead but it didn't make a difference.

Is there something else I'm missing??

Any suggestions much appreciated!!

[daverothwell]

try this:

https://downloads.mysql.com/archives/get/p/6/file/mysql-connector-net-8.0.16.msi

Otherwise just go to the main page (https://dev.mysql.com/downloads/connector/net/8.0.html) and click on Archives at the top and you can search for the older version.

[NatashaT]

Thank you.

I installed 8.0.32 and it's working for me.

[Javierffs]

Thank you, the same version worked for me (8.0.32). 

[Anonymous]

The 8.0.16 version worked like a charm for me.

[NatashaT]

@daverothwell I installed MySQL Connector version 8.0.16 that you reccommended https://downloads.mysql.com/archives/get/p/6/file/mysql-connector-net-8.0.16.msi.

Anyhow, I am not sure what caused a trigger of this software keep changing back to newer version of 8.0.29 by itself, without me uninstall the older version of 8.0.16

Do you or other users experience this same issue? Please advise.

[NatashaT]

Thank you daverrothwell. This older version works for me.

[NatashaT]

I have the same issue since yesterday. I got MySQL Connector Net 8.0.29 installed but I still cannot connect in Power BI. Do you still experience the same issue today?

[Anonymous]

Not sure if this will help, but it worked for me.
After installing the connector, I still got an error when trying to choose "MySQL" as the data source. Instead choosing "ODBC" (the connector itself? I don't know) is what worked as expected.

[MarcusR1]

I'm having the same issue, I tried down-grading to v. 8.0.18 but still get the same error - anyone got a fix?

[NatashaT]

I had this issue in May and I tried download different verison of MySQL but there's nothing work until someone suggested about version 8.0.16 and it works

[RubenGarcia]

Hi!!!! How can I do the installation if in the download of the version I can not find an installer program?

[NatashaT]

I am using MySQL Connector NET 8.0.32 https://downloads.mysql.com/archives/c-net/ at the moment and everything works fine.

[RubenGarcia]

YEEEESSSSSS!!!!!  it´s the solution.   Thanks a lot!!!!