Connection issue Power bi desktop to AWS Rds

[raju8004]

Im Not able to connect AWS rds Database to  power bi desktop, have installed required certificates and NPGSQL as well but still getting certificate error can any one please help me to resolve

[bhanu_gautam]

@raju8004 , Can you share what error you are getting

[raju8004]

@bhanu_gautam 

[Anonymous · Accepted solution]

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.

[raju8004]

@Anonymous  can you please help me with the exact steps what  i need to follow ,because the steps provided by you  is confusing .