Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
We have a PowerBI desktop trying to talk to a PostgreSQL 9.5 server running on Ubuntu 16.04. The postgres server is configured to run SSL. However, this particular power BI has problems with the certificate, so (for now), I'd like it to connect without SSL. So we configure the data source in PowerBI, un-checking "Encryption". However, it still tries to connect to the postgres server via SSL (which I verified by looking at the postgres log).
In the postgres pg_hba.conf file, I configured the line for the powerBI station's IP begins with "hostnossl". Still same error.
How do we get power BI to really not use SSL for this data source.
Yes, we're working on getting it to work with certificate, but (for various reasons), that will take a while.
Thanks
Hi @haimroman,
Per my research, if the data source PostgreSQL is configured with SSL, you have to connect Power BI to it with certificate. You need to copy SSL certificate for the PostgreSQL server to the machine running Power BI Desktop and import it to Windows certificate store. Please refer to this similar thread: Postgres error with Power BI Desktop
Best regards,
Yuliana Gu
The Power BI version is: 2.65.5313.701 64-bit (Dec 2018)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |