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

peltolai's avatar
peltolai
Regular Visitor
9 years ago

For me, the problem wasn't that the certificate wasn't installed.

For me, the problem was that I was using an alias to connect to the database and the certificate didn't include that alias.

We're hosting our database in Amazon RDS.

 

Switching to use the 'real' hostname for the server fixed this issue.