Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |