Forum Discussion
PostgreSQL + powerbi desktop connection error
It seems that there is still problem about the certificate. Maybe you can also try to trust the CA cert on both machines. If issue still persists, I think you can look for help in PostgreSQL community, to find that what certificates need to be installed/trusted on client machine (Power BI Desktop).
I just found a document about PostgreSQL Service and Client certificate. Hope it helps.
Best Regards,
Herbert
Hi Herbert,
Thanks for your help. The certificate I was importing was not the right, after check the posgresql.conf I have had the good one... Or not: Now I have a new error message
"Se produjo un error al leer datos desde el proveedor: 'TlsClientStream.ClientAlertException: CertificateUnknown: Server certificate was not accepted. The specified hostname was not present in the certificate.
I'm trying to connect with an IP direction (internal or external) or with the domain name too and nothing... I'm losing my last hairs!!!
It seems that there is still problem about the certificate. Maybe you can also try to trust the CA cert on both machines. If issue still persists, I think you can look for help in PostgreSQL community, to find that what certificates need to be installed/trusted on client machine (Power BI Desktop).
I just found a document about PostgreSQL Service and Client certificate. Hope it helps.
Best Regards,
Herbert
Hi v-haibl-msft,
You're right again. The problem was the certificate in the server. We have installed the good ones and now Pbi works perfectly.
Thanks again.
Best regards!
Could you please list the right certificates which need to be install on the Power BI Desktop machine if convenient?
I’ve saw several users have the same certificate issue when using this function. If you can list the right certificates here, it will be very helpful to them. Thanks in advance.
Best Regards,
Herbert
The certificates I've installed in the PostgreSQL server and the Pbi desktop ( creating a .PEM) are:
AddTrustExternalCARoot.crt
DV_NetworkSolutionsDVServerCA2.crt
DV_USERTrustRSACertificationAuthority.crt
my_domain_name.com.crt
I hope it will be useful.
Can you pls explain how do you installed the certificates
Really appreciate your help.
Would you mind shareing the steps on how to do it? I have managed to add certificate file in my local PC. Then I saw the error message that you specified and got it solved.
regards,
