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 to connect to one of the most popular databases.
Reason for MySQL error:
The error occurs because you do not have the MySQL Connect connector, or the connector has a version that does not yet support Excel or Power BI or other Microsoft tools or third-party software.
MySQL Connect Solution:
- Check that when connecting the function in Power Query, in case it shows the error
- Enter the website HERE IS WHAT YOU WERE LOOKING FOR: MySQL :: MySQL Connectors
- Install where it says ODBC and ADO.NET
- Run them on your PC
- If it does not work, try an older version