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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nmsivasankar
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.'"

1 ACCEPTED SOLUTION

This was resolved after following the steps below ( Original link on - https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS... )

 

 

@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: https://www.nuget.org/packages/Npgsql/

 

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 https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)

4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm

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

38 REPLIES 38
Anonymous
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? http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm 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 medium.com 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.

Hi,

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,

Levien

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.

Regards!!!

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. 

@alonsoenedel1 

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,
Dale

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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