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

Damian Davies on 05 Jul 2020 23:29:14

RE: MySQL over SSH connection

Although its a bit long winded this works for me: 1. On SQL server, establish a linked server connection to the MySQL database using a PuTTY pipe, 2. Create a SQL database with views of the required MySQL tables using select from openquery functionality, 3. Set up a data gateway to refresh the data through. We only have a relatively small dataset to deal with, but it works.

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:02

RE: MySQL over SSH connection

Hi Microsoft. I've just installed power BI, seems like a great product. All of our data is stored in MySQL but it isn't accessible via SSH. Without this Power BI is a non-starter, unfortunately.

Antons Fedorenko's profile image Profile Picture

John Willker on 05 Jul 2020 23:23:53

RE: MySQL over SSH connection

WTF?, is not a serious product

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:23:36

RE: MySQL over SSH connection

What a Shame! Need SSH support.

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:41

RE: MySQL over SSH connection

How can this not be possible ?
MySQL being used widely even in professional environment, it's a shame.

We need this.

Antons Fedorenko's profile image Profile Picture

Anonymous on 05 Jul 2020 23:22:06

RE: MySQL over SSH connection

Please respond whether we can expect this feature from Power BI Team.

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:21:12

RE: MySQL over SSH connection

SSH!

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:20:59

RE: MySQL over SSH connection

I want to connect from PowerBI to MYSQL that has SSH enabled? I want to create a Datasource for the same. Can anyone help me in connecting to MySQL that has SSH?

Appreciate your help....

Antons Fedorenko's profile image Profile Picture

Power BI User on 05 Jul 2020 23:20:45

RE: MySQL over SSH connection

ssh connection please

Antons Fedorenko's profile image Profile Picture

Jason on 05 Jul 2020 23:20:45

RE: MySQL over SSH connection

This is needed to access RDS/MySQL.