Skip to main content

Power BI

Under Review

MySQL over SSH connection

Vote (637) Share
Antons Fedorenko's profile image

Antons Fedorenko on 28 Jan 2015 18:10:27

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

ea631010 2b42-4908-bd05-52ede1345f6e on 05 Jul 2020 23:34:35

RE: MySQL over SSH connection

We really bred this

Antons Fedorenko's profile image Profile Picture

2bd58910 db77-4b03-94d6-e6ff021f6d8d on 05 Jul 2020 23:34:35

RE: MySQL over SSH connection

Without that feature Power BI is not useful for us

Antons Fedorenko's profile image Profile Picture

3f0be530 6340-4da2-843e-62b9d285ecbf on 05 Jul 2020 23:34:26

RE: MySQL over SSH connection

Your Power BI tool is very powerful. However, like the others, we cannot use since not being support accessing MySQL over SSH.
Please make a big update unless this tool is losing a great pool of customers.

Antons Fedorenko's profile image Profile Picture

17548785 7abe-4048-b3f6-55d64464ce44 on 05 Jul 2020 23:32:50

RE: MySQL over SSH connection

After reviewing multiple platforms we decided PowerBI was the best option, however, without SSH Tunneling this is a non-starter for us. One would think MS would have already built this is in as many other opensource platforms come with it.

Antons Fedorenko's profile image Profile Picture

03e15192 4083-40e8-a82d-a89c9c2f2903 on 05 Jul 2020 23:32:49

RE: MySQL over SSH connection

This seems like a well requested and reasonable feature to include. Any update MS?

Antons Fedorenko's profile image Profile Picture

c1dd230f 2c6f-47bc-b58d-fa33cab8056e on 05 Jul 2020 23:31:38

RE: MySQL over SSH connection

Not being able to access MySQL over SSH is a very big problem for us. Like most have said here, we literally can't even work with Power BI unless this is a feature.

Antons Fedorenko's profile image Profile Picture

a18d8ee2 8667-4578-bf24-ecc17e405a7c on 05 Jul 2020 23:30:57

RE: MySQL over SSH connection

Can't use Power BI anymore. Our new database is only accessible via SSH tunneling. We need this or we have to switch to other BI tooling.

Antons Fedorenko's profile image Profile Picture

99e9ff49 73cf-e711-8111-c4346bacf588 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

2d54dbea 4165-462a-97d9-11f05c2c2f6d 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

7ae5d9d7 96c0-4a2f-9a8c-6bca7e2054d0 on 05 Jul 2020 23:23:53

RE: MySQL over SSH connection

WTF?, is not a serious product