Connecting postgres database for aws rds

[Hemant707]

while connecting to postgres database in power bi, it is showing error- "The remote certificate is invalid according to the validation procedure".

[v-henryk-mstf · Accepted solution]

Hi @Hemant707 ,

For this type of error message, it is usually caused by a certificate conversion or import method error. Refer to the following similar solutions with detailed step-by-step instructions:

If the problem is still not resolved, please provide detailed error information and related operation screenshoot. Looking forward to your reply.

Best Regards,
Henry

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

[Pilares]

Hi @v-henryk-mstf 've tried all the proposed solutions on this forum, including using a qualified aws domain and physical ip address. The standard Postgres adapter in Power BI is still not working. There are no issues when connecting via database management tools, like PGAdmin or DBeaver, or other BI tools, like Qlik Sense, to the AWS Postgres database without using 3rd party ODBC tools. I also don't understand why a PBI gateway is necessary while the AWS Postgres database is running in the cloud. So, I think @Microsoft is probably doing this for a competitive reason, since they also offering an Azure Postgres solution, which seems to be working without any issues.

Regards Frank van Zuilen

[Pilares]

Is there already a working solution available? I've tried above proposed solution, including using a qualified aws domain and physical ip address. The standard Postgres adapter in Power BI is still not working. There are no issues when connecting via database management tools, like PGAdmin or DBeaver, or other BI tools, like Qlik Sense.

Regards Frank van Zuilen

[Pilares]

I've followed the steps, but still getting the "remote certificate" error. Using an ODBC connection works fine though.

Regards, Frank van Zuilen