Power BI and PostgreSQL

[lelalaoui]

Hello team,

I have a database hosted in Postgresql onprem and I want to query the db from Power BI, unfortunatly each time I run a new datasource settings I'm faced with this :

Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"

Knowing that I can connect easily to the database using dbeaver.

Any clue on this ?

Thanks for the great help as always.

Hassan

[amitchandak · Accepted solution]

@lelalaoui , check these two, and how to connect. Do not miss any step

postgresql
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

https://niftit.com/connecting-power-bi-to-postgresql/