Power BI cannot establish secure connection to the PostgreSQL database

[Maciek_1000]

Hi,

I'm trying to establish secure connection to the database (PostgreSQL). However when I try to do this, I'm getting back info that 

Power BI can't connect to the data source using secure connection and instead of that it will do this using non-encrypted one. It's crucial for me to have it secure.

How can I manage this? This is not MS SQL database but PostgreSQL.

And the second one - what does it exactly mean that this connecction is not encrypted?

Thank you for your help

[Maciek_1000 · Accepted solution]

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.

https://www.sonicwall.com/support/knowledge-base/how-can-i-import-certificates-into-the-ms-windows-l...

In my case it had to be a Trusted Root Certification Authorities.

[kymramosrpo]

This worked for me, thanks!

[amitchandak]

@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/

[Maciek_1000]

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.