Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

The remote certificate is invalid according to the validation procedure - Connecting Postgres

Experiencing error while trying to connect the PostgresSQL DB.  I am trying to connect my Power BI Destktop to Postgres RDS hosted on the AWS, below error occuring when I try to setup my connection.



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


This was resolved after following the steps below ( Original link on - )



@v-yuezhe-msft the PostgresSQL connector doesn't work out of the box, you need to do quite a few things first


1. Install Npgsql which allows .NET access to PostgresSQL.  I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here:


You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)


2. Download the AWS public key from here

3. Convert that to a certificate using (convert to PKCS#7/P7B)

4. Import that certificate to the Trusted Room Certificate described here

5. Test access from Power BI desktop using the PostgresSQL connector and it should work


In conclusion it's possible to connect to PostgresSQL on AWS RDS databases but it isn't easy


View solution in original post

View solution in original post


Thanks this worked for me! 

Thank you so much! You saved my day.

Thank you very much for sharing. @nmsivasankar.



Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors