cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI SSH Tunneling

Hi,

 

I am currently using the free version of Power BI in Windows 10.

 

Please let me know how to query data from a MySQL database with SSH tunneling.

 

Thank you.

3 REPLIES 3
Highlighted
Helper II
Helper II

Re: Power BI SSH Tunneling

Hi Kwonsok,

I am not aware of a way to configure two stage authentication in powerBI (I.e SSH into server and login to database). I had a similar requirement to query a PostgreSQL database on a headless linux server, which required using a SSH key file.

If there's a better way I'd like to know myself, but the workaround I used was to use the PuTTY command line tools 'plink' and 'pscp' in a daily job to populate a .csv file with my query and transfer it to my reporting server. You could use the .csv file as is, but I have another job to import the .csv into a SQL Server table.

I did consider trying to make a linked server but I had spent enough time already and I only needed one query. It works well although obviously not great for large amounts of data.

Highlighted
Community Support
Community Support

Re: Power BI SSH Tunneling

Hi @kwonsok

Based on my research , Power BI does not support a MySQL database with SSH tunneling.

There is a similar idea about this issue, please vote it up.

MySQL over SSH connection

Additionaly, please read the discussion under it, someone provided a workaround.

 

Best regards

Maggie

Highlighted
Frequent Visitor

Re: Power BI SSH Tunneling

It's possible to do it.

But you need to open a ssh tunnel with a tool like putty and forwarding ports.

It worked for me following this tuto

https://www.a2hosting.com/kb/developer-corner/mysql/remote-mysql-connections

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors