Forum Discussion
Connect Power BI Desktop to PostgreSQL database through SSH tunnel
MaxW,
What is the error message do you get when using the standard postgre connector in Power BI Desktop?
Besides, you are able to connect to postgresql database using an ODBC connection. There is an example for your reference in the following blog.
http://jaykilleen.com/posts/connect-powerbi-to-a-remote-postgresql-database-encrypted-with-ssl
Regards,
Lydia
Hi Lydia,
Thanks for the reply.
I'm not quite sure which IP I should be using, but using the standard connector and either the db host address or the actual Postgres IP address I just get a connection timeout:
'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'
I've potentially just made some progress; If I open a tunnel to the db host address using PuTTY and forward the postgres port to 127.0.0.1 I get 'PostgreSQL Exception while reading from Stream.' I get this error instantly regardless of the command timeout setting.
For the ODBC connection I had found that blog post, but I'm still unsure how to use it, as it doesn't mention a connection string and I can't find any reference for what to do with my SSH key file..