Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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.
I am facing the same problem. Did you solve it?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |