Forum Discussion
Connect Power BI Desktop to PostgreSQL database through SSH tunnel
Hi, I'm trying to connect to a PostgreSQL datasource from Power BI Desktop. The database is accesed from a Linux server that I tunnel into using an SSH key file. From that server I connect to...
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
My report is connected to PostgreSQL database using ODBC connector and everything works fine.
Now I want to change Import Mode into Direct Query.
Is it possible to connect via ODBC in DQ mode?