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
From the error details, server certificate should be the root cause. Please check that if you get the right certificate and trust it on your Power BI Desktop machine with the correct steps.
Where did you get the certificate of your Postgre server? I found the certificate location as below mentioned in other threads.
In the configuration folder for the PostgreSQL server there is a postgresql.conf file, search it for ssl settings, there is one with the location of the ssl cert. Note NOT the key file which contains the private key, only the cert file which contains the public key. copy it or its content to the machine running Power BI and import using Run | mmc.
Administrators is the minimum group membership required to complete this procedure.
To add certificates to the Trusted Root Certification Authorities store for a local computer
- Click Start, click Start Search, type mmc, and then press ENTER.
- On the File menu, click Add/Remove Snap-in.
- Under Available snap-ins, click Certificates, and then click Add.
- Under This snap-in will always manage certificates for, click Computer account, and then click Next.
- Click Local computer, and click Finish.
- If you have no more snap-ins to add to the console, click OK.
- In the console tree, double-click Certificates.
- Right-click the Trusted Root Certification Authorities store.
- Click Import to import the certificates and follow the steps in the Certificate Import Wizard.
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