Unable to connect to Postgres Database

[tmhalila]

Hello,

I have a dataset deployed in Postgres Database, then I want to connect with the Power BI reporting server - Desktop but I am getting this error immediately after filling up the Server name and Database name then OK. 

Assist, please.

[v-luwang-msft · Accepted solution]

Hi @tmhalila ，

The certificates you need  installed in the PostgreSQL server and the Pbi desktop ( creating a .PEM) are:

AddTrustExternalCARoot.crt

DV_NetworkSolutionsDVServerCA2.crt

DV_USERTrustRSACertificationAuthority.crt

my_domain_name.com.crt

Please find the official document from PostgreSql on how to use the client/server certificates.

https://www.postgresql.org/docs/current/libpq-ssl.html

And similar error refer:

https://community.powerbi.com/t5/Desktop/PostgreSQL-powerbi-desktop-connection-error/td-p/89940 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Shahfaisal]

Try the instructions mentioned in the following forum post:

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666