Forum Discussion
Trying to connect to MY SQL from Power BI
pranim,
Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your 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.
Regards,
pranim,
Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your 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.
Regards,
I tried the same solution and even more but still does not work so what should I do now
I am having similar issues
I am on Mysql 8.2.0
I am connecting to this DB from power bi desktop using my sql connector . PBI version is Version: 2.136.1478.0 64-bit (September 2024)
I downloaded the latest version of connector Connector/NET 9.1.0, restarted the power BI but it would not connect .
When is MS going to improve their products?
I have a solution that worked for me . Hope this works for you as well . Ensure you select the complete option when installing .
