Forum Discussion
PostgreSQL DB Secure Link Established but connection error encountered, please help
Details: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.' Please have this information handy if you choose to create a support ticket. XXXXXX Cluster URI: https://api.powerbi.com Status code: 400 Time: Tue Dec 10 2024 11:00:03 GMT+0800 (Singapore Standard Time)
Hi Yukian - The remote certificate is invalid according to the validation procedure typically occurs when there are SSL/TLS certificate issues between Power BI and the PostgreSQL database.
Modify the SSL mode in your connection string
sslmode=require
Ensure the SSL certificate installed on your PostgreSQL server is valid:
1.It should be issued by a trusted Certificate Authority (CA).
2.The common name (CN) or Subject Alternative Name (SAN) in the certificate must match the PostgreSQL server’s hostname or IP.
Use tools like pgAdmin or psql with the same connection settings to confirm the database accepts SSL connections.
PostgreSQL: Documentation: 17: 18.9. Secure TCP/IP Connections with SSL
PostgreSQL: PostgreSQL Mailing List Archives
Hope the above details helps.
Hi Yukian ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're experiencing.
In addition to the helpful response provided by rajendraongole1 , I would like to share a document that may assist you.
Complete guide to setting up Power BI connecting to PostgreSQL.
Hope this post helps you. If so, kindly accept it as the solution so that it can assist other members and help them find the answer more quickly.
5 Replies
Hi Yukian - The remote certificate is invalid according to the validation procedure typically occurs when there are SSL/TLS certificate issues between Power BI and the PostgreSQL database.
Modify the SSL mode in your connection string
sslmode=require
Ensure the SSL certificate installed on your PostgreSQL server is valid:
1.It should be issued by a trusted Certificate Authority (CA).
2.The common name (CN) or Subject Alternative Name (SAN) in the certificate must match the PostgreSQL server’s hostname or IP.
Use tools like pgAdmin or psql with the same connection settings to confirm the database accepts SSL connections.
PostgreSQL: Documentation: 17: 18.9. Secure TCP/IP Connections with SSL
PostgreSQL: PostgreSQL Mailing List Archives
Hope the above details helps.
Hi Yukian ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're experiencing.
In addition to the helpful response provided by rajendraongole1 , I would like to share a document that may assist you.
Complete guide to setting up Power BI connecting to PostgreSQL.
Hope this post helps you. If so, kindly accept it as the solution so that it can assist other members and help them find the answer more quickly.Hi Yukian ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by me. Please let me know if it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.Hi Yukian,
Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as Answer. Click Yes if you found it helpful.Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi Yukian ,
Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as Answer. Click Yes if you found it helpful.Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!