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:
- Check that the connection function in Power Query, in case it shows the error
- Go to the website HERE THIS IS WHAT YOU WERE LOOKING FOR: MySQL :: MySQL Connectors
- Install where it says ODBC and ADO.NET
- Run them on your PC
- If it doesn't work try an older version