Connect to AWS RDS via VPN

[SiroPW]

Hi All,

I have an AWS RDS (Aurora Postgres) that is inside a private network - only accessable via a VPN.

How can I let PowerBI see the database both on Desktop & Service? I have the VPN running and the Azure IP's whitelisted but still getting "host not found" errors.

Any help is much appreciated, would love to keep using PowerBI (securely).

Thanks!

[v-yingjl]

Hi @SiroPW ,

Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li

[amitchandak]

@SiroPW 

Desktop should work on the machine with VPN and IP. And for service use on perm gateway

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

[SiroPW]

Thanks - at least I know it should work for desktop so I'm pushing through..

However, now I'm receiving:

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

All my googling relates to issues from before the postgresql connector was in place, so not sure where to go from here!

Thanks

[SiroPW · Accepted solution]

For anyone who reads this - I solved it by using the ODBC connector instead (with sslmode parameter)

database=dbname;driver={PostgreSQL Unicode(x64)};port=5432;server=server.eu-w1.compute.server.com;sslmode=require;