Forum Discussion

SiroPW's avatar
SiroPW
Helper I
6 years ago
Solved

Connect to AWS RDS via VPN

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 runn...
Data Protection
Need Help
  • SiroPW's avatar
    SiroPW
    6 years ago

    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;

SiroPW's avatar
SiroPW
Helper I
6 years ago

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's avatar
SiroPW
Helper I
6 years ago

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;