PostgreSQL Connector - The remote certificate is invalid according to the validation procedure

Hi GorujamBI 

 

In order for this to work, you would need to instal a power BI gateway and then install the certificate on the gateway. Once that is done, you can then create a data source connection via your gateway to your. PostGreSql database and then successfully refresh the data.

Hi GorujamBI 

 

This is a common issue that can occur due to SSL/TLS certificate validation failures.

Ensure that the SSL certificate of your PostgreSQL server is valid, not expired, and issued by a trusted Certificate Authority (CA). You can use tools like OpenSSL to verify the certificate chain.
The hostname in your connection string must match the Common Name (CN) or one of the Subject Alternative Names (SANs) on the server's SSL certificate. If there's a mismatch, you'll encounter certificate validation errors.
For more detailed guidance on connecting to PostgreSQL from Power BI, including handling SSL connections, please refer to the Power Query documentation on connecting to PostgreSQL databases:

Power Query PostgreSQL connector - Power Query | Microsoft Learn

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.