How can i connect Latest version of My SQL to power bi ?

Anonymous
2023-07-19T08:41:23+00:00

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

Microsoft 365 Insider | Install, activate, and update | Windows

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.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sjaak Ketting 7,630 Reputation points
    2023-07-19T18:34:45+00:00

    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

    https://community.fabric.microsoft.com/t5/Desktop/error-when-connect-power-bi-to-mysql-service/td-p/2181035

    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.

    Was this answer helpful?

    0 comments
  2. Gérard Oomens 131.2K Reputation points Volunteer Moderator
    2023-07-19T10:17:47+00:00

    Resubmit your question in the Power BI forum:

    Forums - Microsoft Fabric Community

    Was this answer helpful?

    0 comments