This connector requires one or more additional components to be installed before it can be used.
Oh Snap!

Please turn off your ad blocking mode for viewing your site content

img

This connector requires one or more additional components to be installed before it can be used.

/
/
/
5623 Views

If you get the error when trying to connect to a MySQL database in Excel or Power BI of "This connector requires one or more additional components to be installed before it can be used." Also for people who just want to install the MySQL Connector and thus be able to connect to one of the most popular databases.

Reason for MySQL error:

The error occurs because you don't have the MySQL Connect connector, or the connector has a version that doesn't yet support Excel or Power BI or other Microsoft tools or third-party software.

MySQL Connect solution:

  1. Check that the connection function in Power Query, in case it shows the error 
  2. Go to the website HERE THIS IS WHAT YOU WERE LOOKING FOR: MySQL :: MySQL Connectors
  3. Install where it says ODBC and ADO.NET
  4. Run them on your PC
  5. If it doesn't work try an older version

    This div height required for enabling the sticky sidebar
    en_USEN