topic Re: Unable to connect to Postgres Database in Report Server

Unable to connect to Postgres Database

tmhalila — Thu, 28 Jul 2022 05:32:07 GMT

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.

Re: Unable to connect to Postgres Database

Shahfaisal — Thu, 28 Jul 2022 17:04:18 GMT

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

Re: Unable to connect to Postgres Database

v-luwang-msft — Tue, 02 Aug 2022 06:20:16 GMT

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