PostgreSQL DB Secure Link Established but connection error encountered, please help

[Yukian]

PostgreSQL Database connection link 

PGAdmin 

From Power BI services Msg

Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a

connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.



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)

Please help 

[rajendraongole1 · Accepted solution]

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.

[v-pagayam-msft]

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!

[v-pagayam-msft]

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!

[v-pagayam-msft]

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.

[v-pagayam-msft · Accepted solution]

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.

[rajendraongole1 · Accepted solution]

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.