Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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!