Forum Discussion
Unable to connect to Postgres Database
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.
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 RegardsLucien
2 Replies
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
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 RegardsLucien
