Connecting MySQL Benchmark with Power BI

[Gutierrez4]

Hello,

I am trying to connect to an SQL IP Adress. I am able to access it through MySQL Workbench, but when I try to connect it to Power BI the following error shows up...

So, here is what I have in MySQL Workbench program which I like to connect....

 

By writing the IP Adress in SQL connect with or without the port number the error persists.

I already opened the port number in the firewall and the error persists.

I am able to connect via Python but not Power BI.

Any suggestions???

Thanks

[V-lianl-msft · Accepted solution]

Hello @Gutierrez4 ,

For the above error, make sure that you have specified the correct server name, which can be serverip: portno or servername. If you use the server name, place the host name in the Server field and in the Database field.

Also make sure that the MySQL service is running on the server to which you want to connect.

You can also try using the ODBC connection for MySQL.

https://community.powerbi.com/t5/Desktop/Unable-to-connect-MYSQL-Details-quot-MySQL-Unable-to-connec...

Best regards
Liang
If this post helps, then consider Accept it as the solution to help other members find it faster.

[Greg_Deckler]

@Gutierrez4 Seems like you should be using the MySQL connector and you are using the SQL Connector.

[Gutierrez4]

My server name is GPower and y want to extract tables from database.

Cant connect.

This is now the error.