Forum Discussion

Peterfrb2's avatar
Peterfrb2
Regular Visitor
7 years ago
Solved

Problem connection Power BI to MySQL data source

For a homework assignment, I have uploaded MySQL for the first time, created a schema and table and populated the table with a few records.  The recommended approach for downloading MySQL content int...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Peterfrb2 ,

    Before we can connect to a MySQL database, we need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on our computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).


    After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.


    If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

     

    (Note: Please understand that this link is provided above with no warranties or guarantees of content changes, and confers no rights.)

    Best Regards,

    Cherry

     

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Thanks to you my problem is resolved now.

SB1530's avatar
SB1530
New Member
2 years ago

hello,

 

i have installed connector and still getting the same error.

i dont see connections option in SQL server community and i reconfigure sql workbench still getting the same error,

 

Please guide how can i resolve the issue.

 

Thank you