I just installed power bi and trying to connect to mysql server. I have server downloaded but can't

[bjo7000]

I just installed power bi and trying to connect to mysql server. The connection doesn't work and I want to try change TCP/IP setting at mysql configuration manager, which is alleged to be installed along with the server installation, but I can't locate the file. Should I reinstall mysql server?

[amitchandak · Accepted solution]

@bjo7000 , make sure MySQL can connect to external ip using the user. For each user, you have given permission to connect to external ips. Or Ip need to whitelisted

Also, make sure you have installed the latest version on mysql .net connector -https://dev.mysql.com/downloads/connector/net/

[nvprasad]

Hi,

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.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad