Antons Fedorenko on 28 Jan 2015 18:10:27
- Comments (178)
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.
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.
RE: MySQL over SSH connection
WTF?, is not a serious product
RE: MySQL over SSH connection
What a Shame! Need SSH support.
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.
RE: MySQL over SSH connection
Please respond whether we can expect this feature from Power BI Team.
RE: MySQL over SSH connection
SSH!
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....
RE: MySQL over SSH connection
ssh connection please
RE: MySQL over SSH connection
This is needed to access RDS/MySQL.