Power BI

Under Review

MySQL over SSH connection

Vote (796)

Antons Fedorenko on 28 Jan 2015 18:10:27

Comments (177)

Comments (177)

Zach on 05 Jul 2020 23:08:51

RE: MySQL over SSH connection

please add this feature

tom on 05 Jul 2020 23:08:36

RE: MySQL over SSH connection

Definitely a need for our BI work.

Power BI User on 05 Jul 2020 23:07:17

RE: MySQL over SSH connection

We NEED ssh

QS on 05 Jul 2020 23:07:09

RE: MySQL over SSH connection

A colleague
(Brock Ferguson) shared this idea with me and it solved my problem to a certain degree. Here's what we would try first:
Create a new EC2 server.

On this server, setup SSH port forwarding to the RDS via your existing public SSH server:

ssh -iprivate_key.pem -L 3306:rds-hostname.aws.com:3306 username@your-existing-ssh-server

You will need to grant access from this SSH server to your other server via a private key.

Restrict access to your new EC2 server to port 3306, and to only the IP(s) used by Power BI.

Connect to MySQL:

host: IP of new EC2 server
username: RDS user
pass: RDS pass
This should work by granting you access to your private network by using your new EC2 server as a bastion server. New EC2 -> existing SSH server -> RDS.

Ben Oastler on 05 Jul 2020 23:07:02

RE: MySQL over SSH connection

This has been Under Review since 2015, can we please get an update on this?

Egbert on 05 Jul 2020 23:03:51

RE: MySQL over SSH connection

ssh please

Power BI User on 05 Jul 2020 23:03:42

RE: MySQL over SSH connection

For the many asking about mysql and ssh, you can tunnel your connection with Putty and then connect to the db like a local db. Can't say much about auto-update of the data or publishing.

I see other softwares using SSL but not SSH