ERROR: The remote certificate is invalid according to the validation procedure

[MiguelDLR]

Good day.

I have been working with Power BI for 1 year consulting a PostgreSQL database in AWS RDS, today out of nowhere I started getting the following error when I wanted to update both in Desktop and in Services: The remote certificate is invalid according to the validation procedure, and nothing has changed in the server configuration.

I also already performed these steps and nothing:

You need to connect over SSL to AWS which isn't setup by default

1. Install Npgsql which allows .NET access to PostgresSQL. I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/

2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)

4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm

5. Test access from Power BI desktop using the PostgresSQL connector and it should work

Do you know any other solution?

[manish_kumawat]

Hi, I created a video to solve this problem.

Video link: https://youtu.be/a641lOBoqUw

[Anonymous · Accepted solution]

Hi,@MiguelDLR 

Regarding the issue you raised, my solution is as follows:

1.First, you can disable encryption:

Here are links to similar issues:

AWS Postgres: 'The remote certificate is invalid' - Microsoft Fabric Community

2.Second, you can check if the certificate on the server is updated and update the key..For PostgreSQL DB hosted on AWS RDS, it necessitates an on-premises data gateway for refreshing from PBI Service, as the AWS public key needs to be installed on the gateway machine.

Here are links to the relevant documentation:

Solved: PostgreSQL Connector - The remote certificate is i... - Microsoft Fabric Community

Solved: Invalid Remote Certificate - Microsoft Fabric Community

Here are links to the relevant documentation:

Solved: Invalid Remote Certificate - Microsoft Fabric Community

3.Finally, you can try setting up an ODBC connection.

How to Connect to an ODBC Data Source From Power B... - Microsoft Fabric Community

Here are links to similar issues:

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community

If you have any new discoveries, please share them with us

Best Regards,

Leroy Lu

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