How to connect mysql database from power bi desktop over ssh

[Deep]

I want to connect power bi desktop to a remote MySQL database. In order to connect to MySQL, I have Bastion server credentials and DB credentials.

I used putty to connect to the Bastion server and I successfully make a connection with the server and able to access MySQL. But when I tried to connect to MySQL from power bi desktop then it shows an error "MySQL: Unable to connect to any of the specified MySQL hosts." 

[negi007 · Accepted solution]

@Deep Have you tried using ODBC DSN connection to mysql db. This might help you in connecting to the MY SQL DB from powerbi. I have used similar approach to connect mysql db which was in AWS cloud to connet from powerbi. However, if your DB is required VPN connectivity, you may also need to connect to VPN before using ODBC DSN.

Further, MySQL workbench is a different tool to connect to your cloud DB. It will not help you in your powerbi connectivity. 

You may refer to below link (skip 1st 60 seconds)

https://www.youtube.com/watch?v=fZV1VSRF0Zg

[amitchandak]

@Deep , Have installed https://dev.mysql.com/downloads/connector/net/

And allowed ip of power bi Dekstop in MySQL?

[Deep]

@amitchandak How this connector connects power bi desktop to remote MySQL DB?
Do I have to connect MySQL workbench to remote MySQL DB then power bi to the workbench?

and from where I get the power bi desktop IP?
can you please elaborate

[amitchandak]

@Deep , This .net connector will help power bi to connect to MySQL. If on the same machine you are able to connect with other tools. means IP access has no issues.

For IP, you can query on google What is my IP

[Deep]

@amitchandak unable to connect. It shows "can't connect to mysql server on 'ip' (10060)"

[amitchandak]

@Deep , That means user is not enabled for outside IP. 

refer if this : https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-addres...

[Deep]

@amitchandak IP is not an issue for us because we are connected through VPN and I am able to connect through MySQL using TCP/IP over ssh where I have to fill both server and DB credentials. But when I try to connect through power bi desktop there is no option for server host and password. Here I only fill DB details. I think that's the issue with Power bi desktop and connector.

Is there is any way to do so?

[vinay377]

Hello Deep,
Did you find the solution for this scenario.
If you have solved it, can you please guide me on how to make the connection.

[Anonymous]

I have the same problem. Did you find any solution?