This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have successfully installed Power Bi Desktop in my system And MYSQL workbench is already working in my system . Now I want to connect Power Bi with MYSQL but its throwing me the following error " This connector requires additional components to be installed before"
Now i have tried alot , i have already installed required connector from original site and these are following " ADO.NET Driver for MySQL (Connector/NET) ODBC Driver for MySQL (Connector/ODBC)" But it still not working , I have tried alot , I have check firewall its also fine . Please tell whats the problem now after connectors why its still not working ???
2.119.666.0 this my Power Bi version 8.0.33 this is MYSQL version
Processes in Microsoft 365 Insider for installing preview builds, activating subscriptions, and keeping apps up to date with the latest Insider features.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Resubmit your question in the Power BI forum:
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 40%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hello Abdur Rafay_733,
To connect Power BI to MySQL database, you need to follow these steps:
1. Install Power BI Desktop on a system that can access your MySQL database.
2. Select the MySQL database option in the connector selection.
3. In the MySQL database dialog, provide the name of the server and database.
4. Select the Database authentication type and input your MySQL credentials in the User name and Password boxes.
5. Select the level to apply your credentials to.
6. Once you’re done, select OK.
7. In Navigator, select the data you require, then either load or transform the data.
You mentioned that you have already installed required connector from original site and these are following
“ADO.NET Driver for MySQL (Connector/NET) ODBC Driver for MySQL (Connector/ODBC)” but it still not working.
You may want to check if you have installed the correct version of the connector as some versions might cause an error message
"This connector requires one or more additional components to be installed before it can be used."1
If you are still having issues connecting Power BI Desktop with MySQL after following these steps,
you may want to check if your firewall is blocking the connection2.
1. MySQL database
https://learn.microsoft.com/en-us/power-query/connectors/mysql-database
2. Connect MySQL to PowerBI / Why Connect MySQL to Power BI?
https://help.scalegrid.io/docs/connect-mysql-to-powerbi
3. Import data from Azure Database for MySQL - Flexible Server in Power BI
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop
Some common errors when connecting Power BI to MySQL include:
"This connector requires additional components to be installed before it can be used."
"Could not load file or assembly ‘Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106’
or one of its dependencies."
"It can’t find my Sales Data db."
error when connect power bi to mysql service
Power BI can't connect to MySQL DB
https://stackoverflow.com/questions/65635269/power-bi-cant-connect-to-mysql-db
I hope this helps! Let us know if you have any other questions.
Best Regards,
Jacquito.