Connection problems with MySql database

Hi Anonymous,

Firstly, are you able to connect to the database through MySQL workbench? Make sure that MySQL workbench is installed on the same machine with Power BI Desktop. If the connection fails, please follow the guide in this blog to troubleshoot this issue.

Secondly, if you are able to connect to database using MySQL workbench, please use same connection parameters in Power BI Desktop, and also add port number with server name to connect to MySQL.

Thirdly, ensure that you 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).

Thanks,
Lydia Zhang

Thanks for your v-yuezhe-msft indications, were the basis for finding the solution.
The solution is:
> Install the MySQL Connector / Net 6.6.5 for Microsoft Windows Connector on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).
> After this you must create a user with access permissions to the database, in this case I use phpmyadmin, which is the default manager in xampp

It is very important that the user on behalf of the server is created as%, so you can access from any client, as shown in the example. If you want to give access only from certain clients, you must enter the corresponding hostname.

>In Power Bi, make the connection from the Database tab, with the previously created user, password and database access level.

I hope these steps are useful for someone else and I thank all those who contributed me to the solution