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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Connection to Postgres error

Hello community,

 

I have a problem with Power BI when it connects to a Postgres DB on a Linux server.
I installed Power BI on my local machine and tried to connect to the Postgres but the same error appears everytime, the CERTIFICATE problem.

I copied the public certificate of Postgres to my local machine, converted it to a .crt file and installed it. Nothing works.
There is also a small thing, when I install it or import it, Windows tells me 'Import successfull' but I can't see it in the certificates list.
Did anyone have the same issue? Please help me 🙂

 

You can see the error below.

 

Details: "An error happened while reading data from the provider: 'Npgsql.Tls.ClientAlertException: CertificateUnknown: Server certificate was not accepted. Chain status: A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider.
. The specified hostname was not present in the certificate.
   at Npgsql.Tls.TlsClientStream.SendAlertFatal(AlertDescription description, String message)
   at Npgsql.Tls.TlsClientStream.ParseCertificateMessage(Byte[] buf, Int32& pos)
   at Npgsql.Tls.TlsClientStream.TraverseHandshakeMessages()
   at Npgsql.Tls.TlsClientStream.<GetInitialHandshakeMessages>d__43.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Npgsql.Tls.TlsClientStream.<PerformInitialHandshake>d__72.MoveNext()'"

Status: Investigating
Comments
v-robertq-msft
Community Support
Status changed to: Investigating