Forum Discussion
Power BI cannot establish secure connection to the PostgreSQL database
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
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.
4 Replies
- amitchandak
Super User
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.
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.
- kymramosrpo
Advocate V
This worked for me, thanks!
