Connection issue Power bi desktop to AWS Rds

Regarding the issue you raised, my solution is as follows:
1.First, check that the certificate is imported into the Trusted Room certificate described here: http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm

2. You can disable encryption:

 

 

Here are links to similar issues:

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

 

3. 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

 

4.Here are links to similar issues:

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community
Solved: ERROR: The remote certificate is invalid according... - 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.