Forum Discussion
Error message connecting to MySQL
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.
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.
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.