Forum Discussion

emnik's avatar
emnik
New Member
6 years ago

Certificate error connecting Power BI to RDS PostgreSQL: 'The remote certificate is invalid ...'

Hi there,

 

We are getting a certificate error when connecting from mainland Europe to an AWS RDS PostgreSQL instance in the eu-west-1 AWS region. When connecting from within the UK (on a different machine) it works. The Europe machines are able to connect to an RDS instance in the eu-central-1 region. They have imported all RDS certificates as per https://community.powerbi.com/t5/Desktop/The-remote-certificate-is-invalid-according-to-the-validation/td-p/531475 and similar threads. The certificates are still valid. My own machine does *not* have the RDS certificates but I don't get a certificate error, I can connect fine. Telnet tests confirm the Europe machines can connect fine to the RDS instance.

 

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

 

Any ideas? 

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    6 years ago

    Hi emnik ,

    For your issue, if you want to solve the problem quickly,  I think that you'd better create the support ticket here to get the most efficient help. 

    Best  Regards,

    Cherry