Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Advocate II
Advocate II

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

Not applicable

Please help me i just creat a model in power BI desktop with data base of postgreSQL but whene i publish it i could not establish the connexion betwean dashboard and the db am really tired from it could not find the answer please help me

Hi - the link in step (4) no longer works and so I wondered whether anyone has the instructions please? Thanks

@jpd99see my response earlier in this thread for the guides I used to connect Postgres to Power BI Desktop and Power BI cloud

@wshapiro thank you!  I actually had a go using the instructions in your earlier post but wasn't able to view the whole page at sslsupportdesk.  I also tried the video at for the import but it wouldn't work.  That all said, I'll give it another go from scratchg.  Fingers crossed.  Thanks again

Hi @nmsivasankar ,


Thank for your guide. It succeced to connect aws rds postgres on Power BI Desktop. But when I publish to cloud. It has error on Power BI Cloud.


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


2019-12-31 19_51_38-TestPostgreSQL - Power BI.png

Could you please take a look?


Thank and Regard,

I am also facing the same issue and cannot disable encryption due to security requirements!

@v-jiascu-msft - any ideas?

Hello All,


I am also facing same issue. 

@quangdatnth @ledeh @akoeller

Did you got any solution. If you have can you please help me on this.


Thank You.

We are facing the same issue. Was anyone able to resolve this issue on Power BI Service?

Same issue with cloud service. Please help.


I also managed to connect in PBI desktop, but once trying to refresh in the service, it gives the same error.

Any idea how to solve this?

Thanks & best regards,


Im having the same issue.

Hello, Test this..

File -> Data Source Settings -> Edit Permissions worked for me. In the Encrypted Connections Option Uncheck the Check.


Thank you so much, it has helped me

This worked but only issue is you have to sync data manually is there any way how can i connect and then set for auto dataset update with AWS RDS PostGresSQL with Power BI?

i tried cerifitcation method.

i tried ODBC.

i tried unencryption method> this work but only issue cant set auto refresh.


how can i set auto refresh of dataset with unencryption method of connection. 


You saved me several hours, thanks!

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


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.