Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
In my case it had to be a Trusted Root Certification Authorities.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |