Forum Discussion

Gaël's avatar
Gaël
Advocate II
9 years ago
Solved

PostgreSQL + powerbi desktop connection error

Hi!   I'm trying to connect my PB desktop to a PostgreSQL DB but the following error is generated:   Detalles: "Se produjo un error al leer datos desde el proveedor: 'TlsClientStream.ClientAlertE...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Gaël

     

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Gaël

 

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

Gaël's avatar
Gaël
Advocate II
9 years ago

v-haibl-msft

 

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.