Importing data from postgresql through SSH

[Anonymous]

What's the best way to import data from a postgresql server with SSH tunneling?

I have data that resides in a cloud server that can only be queried through an SSH tunnel.

[Icey]

Hi @Anonymous ,

Sorry, I don't have a Postgresql database and can't test for you.

But I find some documents and hope they can help you:

PowerBI and PostgreSQL : SSL, Let’s encrypt and Gateway;

Connect Excel to PostgreSQL through SSH Tunnel (Part 1);

Connect Excel to PostgreSQL through SSH Tunnel (Part 2);

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the response @Icey , however I'm still unable to connect after trying all your suggestions.

I'm able to establish remote access to the server with PuTTY but that's as far as I'm able to go. When attempting to pull data into pbi desktop using the postgresql plugin I get the following:

Did some research and some people said to try installing an earlier version (3.2.7) of npgsql with the GAC installation. I did that and now I get this:

Help in resolving this would be greatly appreciated.

[Deep]

I am facing the same problem. Did you solve it?