Why my MySQL Connector is not working on a 64bit Microsoft Power BI?

[Aleeya]

I have tried to install the 32-bit version of MySQL Connector, but my Microsoft Power BI is still in a 64-bit version. So it's not compatible. I tried to find the 32-bit version of Microsoft Power BI but couldn't find one. I was excited about upgrading my Power BI without knowing about the problem it had. 

If I download the suggested connector version, my Power BI still cannot detect the connector.

[v-nmadadi-msft]

Hi @Aleeya 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @Aleeya 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @Aleeya 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Aleeya]

Nope. Still not helping. Still appears the same pop-up.

[v-nmadadi-msft · Accepted solution]

Hi @Aleeya  ,
Thanks for reaching out to the Microsoft fabric community forum.

Please make sure the connector is correctly installed,
To determine if the package is installed correctly, open a PowerShell window and run the following command:
[System.Data.Common.DbProviderFactories]::GetFactoryClasses()|ogv

If the package is installed correctly, the MySQL Data Provider is displayed in the resulting dialog. For example:

If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[Akash_Varuna]

HI @Aleeya It is because the 32-bit MySQL Connector is incompatible with the 64-bit version of Power BI. To resolve this, uninstall the 32-bit MySQL Connector and install the 64-bit version of the MySQL Connector/ODBC driver. Ensure the connector version matches your Power BI architecture (64-bit). You can download the 64-bit connector from the MySQL official website, and once installed, the connection should work without additional compatibility issues.

[pankajnamekar25]

Hello @Aleeya 

  Uninstall any existing 32-bit MySQL Connector from your system.

 Go to the official MySQL downloads page:
https://dev.mysql.com/downloads/connector/odbc/

 Download and install the 64-bit MySQL Connector/ODBC.
Choose the Windows (x86, 64-bit), MSI Installer option.

 After installation, restart Power BI Desktop.

Try connecting to MySQL again from Home > Get Data > MySQL database.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.