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

     

opop's avatar
opop
New Member
3 years ago

I managed to get it to work by uninstalling the Power BI desktop and MySQL Connector and reinstalling everything with the order below.  I have Microsoft. NET Framework 4.5, 4.5.1, and 4.5.2 on my machine.  

 

  1. Install MySQL Connector NET 8.0.31 (I tried with 8.0.33 but it doesn't work on my machine)
  2. Install MySQL Installer - Community
  3. Install MySQL Workbench 8.0 CE
  4. Install Power BI Version: 2.116.966.0 64-bit (April 2023) from the Microsoft Store

 

Amin_Adham's avatar
Amin_Adham
Regular Visitor
3 years ago

Thanks dear Opop.
my problem is also solved with chnging the version.
I had problem with ver 8.0.33, but changing to 8.0.31 solved my problem.

Regards,
Amin