need help: RDS AWS->data flow: "invalid certificate" errors on one database, but other works fine?

[Anonymous]

note: only the database name is different here, its the same server!

This works:
PostgreSQL.Database("production-api.mumbojumbo.eu-central-1.rds.amazonaws.com", "database-name-test")

This does not work:
PostgreSQL.Database("production-api.mumbojumbo.eu-central-1.rds.amazonaws.com", "database-name-production")

--> "DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"


what is wrong here? how can i troubleshoot this?

[v-yangliu-msft]

Hi  @Anonymous ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/m-p/531475

https://community.powerbi.com/t5/Issues/issues-connecting-data-flow-to-postgresql-hosted-on-AWS/idi-p/2034242

https://stackoverflow.com/questions/53921336/an-error-happened-while-reading-data-from-the-provider-the-remote-certificate-i

https://stackoverflow.com/questions/60102636/power-bi-postgresql-data-import-error-the-remote-certificate-is-invalid-accord

Best Regards,

Liu Yang

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