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 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!

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;

4 Replies

    • 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;

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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