Force Power BI NOT to use SSL

[haimroman]

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

[v-yulgu-msft]

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

[haimroman]

The Power BI version is:   2.65.5313.701 64-bit (Dec 2018)