Error message connecting to MySQL

[Anonymous]

Choosing MySQL database in the Get Data dialogue window returns a message "This connector requires one or more additional components to be installed before it can be used." I clicked Learn More and installed the connector at that link. When I reattempted a connection Power BI returned the same message.

[Pbidev342]

Check out this video guide for correct drivers https://youtu.be/EL3DdMVAUnQ?si=ie7O3RiB0nrIap0B

[Anonymous · Accepted solution]

Hi  @Anonymous ,

From the error message, it looks like you didn't install the correct MySQL connector successfully. You can download the ODBC Driver for MySQL(connector/ODBC) from below link, this connector worked well in my environment.

Or download x64 bit MySQL connector and install yourself.

https://community.powerbi.com/t5/Power-Query/Cannot-connect-to-local-MySQL-database/td-p/49947

This is the related document, you can view this content:

https://stackoverflow.com/questions/44793519/cannot-install-microsoft-power-bi-postgre-sql-connector

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToddChitt]

@Anonymous 

I am having the same issue. I can confirm that I have Power BI 64 bit installed (from the Help menu). I can also confirm that I have the X64 architecture installed for both MySQL Workbench and Connector/ODBC under MySQL Installer.

Yet I am still getting the error when trying to connect Power BI to MySQL: "This connector requires one or more additional components to be installed before it can be used." So WHAT component does it think I need, and how do I find out? This link under "Learn more' just takes me to the place where I installed the connector in the first place.

Any suggestions?

Thanks in advance.