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!!

[eliamartali]

So I tried everything and finally it worked.

1) Remove everything related to power bi and mysql/connector using control panel

2) Go to registry editor-Software-WOW6432Node and remove MySQL, MYSQL  AB
3) Go to registry editor-Software remove ODBC
4) Go to registry editor-Software remove MySQL AB
5) Locate MySQL folder and remove all its contents (if exist)
6) Remove cache data from %LocalAppData%\Microsoft\Power BI Desktop

7) now restart computer. Install 8.016 server and ODBC and NET connector for your arcchitecture
😎 restart computer. Install Power bi desktop

Hopefully helps

[eliamartali]

I tried everything. This is ridiculous.

I end up with seting up data pipiline with a python connector connecting to the mysql database and retreiving data as csv file

then I will connect that csv file to the power bi...

Thanks Microsoft 👍

[anvesj1212]

currently 8.0.31 is only working. Latest version is not working for POWER BI. 

Trust me. This will save you a ton of time. 

[ToddChitt]

Version 8.0.32 (latest as of this writing) worked for me, whereas all previous menioned here did not. Go figure

[DataSafr]

Just yous version mysql both 8.0.16 

[MarcusR1]

UPDATE: I went to install MySQL Community on a fresh device and the dialogue box came up with a mandatory upgrade : Connector/NET 8.0.31 (Upgrading Connector/NET 8.0.16)  - see attached. So maybe this is a fix from MS/Oracle? it would be nice to know so that we can all use the latest version - MS/Oracle are you there? can you respond?

[sweetstar]

Why the hell does MS keep developing software like this for decades?

[sherbert]

Hey I'm on Windows 11. I had the same issue with MySQL Connector Net 8.0.29. My fix was uninstall MySQL Connector Net 8.0.29. Then I installed an older version. MySQL Connector Net 8.0.23 to be specific. Seems like bug with version 8.0.29. On the download page click Archives tab to try an older version.

[Anonymous · Accepted solution]

I installed MySQL server v8.0.16 and connector v8.0.16 and it worked. I guess it is worth trying. Good luck! 

[daverothwell]

Thank you! This worked for me. Kind of unbelievable that newer versions of the connector fail at their main reason for existing.

[NatashaT]

@Anonymous Could you please pass me the link of what you just installed? Thank you

[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.

[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?

[Brenden]

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