I'm trying to connect power bi with postgreSQL hosted on AWS RDS, but error certificated

[Anonymous]

I'm trying to connect power bi with postgreSQL hosted on AWS RDS. I am using the "PostgreSQL Database" component, this database can only be connected via an IP using a VPN. When filling in the server and database in the component, the following error is displayed:

"An error occurred while reading data from the provider. The remote certificate is invalid, according to the validation procedure"

I need to use this direct connector instead of a local gateway because I will need to schedule automatic updates in Power BI online.

The postgre database can only be accessed using a VPN

I don't want to use the local ODBC gateway because I need a direct connection to be able to scheduler

Help me. Tanks!

[djurecicK2]

Hi @Anonymous ,

 This thread should help you:

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