Power BI Desktop : Npgsql 3.0.3 error

0 votes

When I tried to connect to an AWS Postgres database that requires SSL, I received the following error. I've gotten a recent upgrade of npgsql 3.0.3 which gives me trouble connecting. Any suggestions on this?

DataSource.Error: TlsClientStream.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain could not be built to a trusted root authority. . at TlsClientStream.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos) at TlsClientStream.TlsClientStream.TraverseHandshakeMessages() at TlsClientStream.TlsClientStream.GetInitialHandshakeMessages(Boolean allowApplicationData) at TlsClientStream.TlsClientStream.PerformInitialHandshake(String hostName, X509CertificateCollection clientCertificates, RemoteCertificateValidationCallback remoteCertificateValidationCallback, Boolean checkCertificateRevocation) Details: DataSourceKind=PostgreSQL

Dec 14, 2018 in Power BI by Shubham
• 12,110 points
52 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can fix this issue by installing the Amazon RDS public certificate on your machine.

You can follow these steps to do so.

  1. Download the AWS RDS public certificate 
  2. Create a .crt file from the .pem file downloaded. You can find the sample instructions right here 
  3. Install the certificate (.crt file) on your machine. 
  4. Connect!
Cheers.
answered Dec 14, 2018 by Upasana
• 7,480 points

Related Questions In Power BI

0 votes
2 answers

DataFormat.Error Power BI Desktop

The invalid escape sequence is caused by ...READ MORE

answered Sep 25, 2018 in Power BI by Nilesh
• 6,900 points
502 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 35,720 points
47 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 35,720 points
60 views
0 votes
1 answer

Display power bi report on my desktop application

Power BI has a new feature called ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 35,720 points
22 views
0 votes
1 answer

Power BI : npgsql installation

As a general rule Npgsql can be ...READ MORE

answered Nov 27, 2018 in Power BI by Shubham
• 12,110 points
70 views
0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,040 points
342 views
0 votes
1 answer

Install postgreSQL on Ubuntu

Installing PostgreSQL on Ubuntu is very simple, ...READ MORE

answered Mar 22 in Database by Nitesh
14 views
0 votes
1 answer

Access progrs prompt without switching accounts

Use the following to get the postgres prompt ...READ MORE

answered Mar 22 in Database by Mahi
7 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 7,480 points
118 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 7,480 points
30 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.