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,
Today, current version is 8.0.18. It can be downloaded from https://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-8.0.18.msi
Once I upgraded to mysql-connector-net-8.0.18, it will throw "MySQL: Unable to connect to any of the specified MySQL hosts." error. When I use the latest version 8.0.27, it will throw ""An error happened while reading data from the provider: 'Connection option 'server' is duplicated" error message.
My database version remain unchanged at 5.1.73 - but now with the connector upgrade, I am no longer able to connect. The previous version 6.6.5 no longer works 😞 Any ideas?
Anonymous I Cannot find any MY SQL conector/net for x64 version of power BI. I would be very pleased if you could help me find it
connectors can be found here
odbc
https://dev.mysql.com/downloads/connector/odbc/
net
https://dev.mysql.com/downloads/connector/net/8.0.html
What if I already have installed some 8.x version ?
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 .
