Issue in connnecting Power BI Desktop with PostgreSQL

[Kuberkumark]

Not able to import Data from PostgreSQL to Power Bi Desktop in my local machine. I was able to create connection between the Server and my local machine using dbeaver and Tunnelling was done through SSH Window and Certificates in SSL Window.

Certificates placed were  - client-cert.pem, client-key.pem, server-ca.pem files.

But the same is not working for Power BI Desktop, is there something that I'm missing here, evern @Anonymous  @Microsoft @Anonymous @GuyInACube  @RezaRad   Team was not able to help. with this issue, someone, please help.

Thankyou in Advance.

[Idrissshatila · Accepted solution]

Hello @Kuberkumark ,

check this https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Desktop-ODBC-Connectors-to-PostgreSQL-wit...

this once happened to me and i installed the postgresql driver for ODBC and then used the connection ODBC in power bi and it worked.

https://odbc.postgresql.org/