Skip to main content

Power BI

Under Review

MySQL over SSH connection

Vote (808) Share
Antons Fedorenko's profile image

Antons Fedorenko on 28 Jan 2015 18:10:27

Comments (178)
Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:09:31

RE: MySQL over SSH connection

This feature is badly needed..

Antons Fedorenko's profile image Profile Picture

Zach on 05 Jul 2020 23:08:51

RE: MySQL over SSH connection

please add this feature

Antons Fedorenko's profile image Profile Picture

tom on 05 Jul 2020 23:08:36

RE: MySQL over SSH connection

Definitely a need for our BI work.

Antons Fedorenko's profile image Profile Picture

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

RE: MySQL over SSH connection

We NEED ssh

Antons Fedorenko's profile image Profile Picture

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.

Antons Fedorenko's profile image Profile Picture

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?

Antons Fedorenko's profile image Profile Picture

Egbert on 05 Jul 2020 23:03:51

RE: MySQL over SSH connection

ssh please

Antons Fedorenko's profile image Profile Picture

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

Antons Fedorenko's profile image Profile Picture

Alex P on 05 Jul 2020 23:01:40

RE: MySQL over SSH connection

This would be nice.

Antons Fedorenko's profile image Profile Picture

Daniel on 05 Jul 2020 23:01:06

RE: MySQL over SSH connection

SSH is a must. Without it I will need to look at other Software