Forum Discussion
Power BI cannot establish secure connection to the PostgreSQL database
I've manage to connect securely with the server using certificate generated from the server. I've installed it on my computer following this instructions.
In my case it had to be a Trusted Root Certification Authorities.
Maciek_1000 , Power bi will connect only SSL enabled Postgresql.
Please do not miss any of the steps mentioned in the solutions
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/
Thank you amitchandak for your suggestion. I've managed to connect to the database with Power BI connector. But I wanted to connect securely. That means that it's not impossible to connect without encryption.
I'm trying to get through the solution to import certificate to windows. I'm waiting for the certificate to be provided from my PostgreSQL database administrator and I'll see if it's capable.