Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Proud to be a Super User! | |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |