Forum Discussion

haimroman's avatar
haimroman
New Member
7 years ago

Force Power BI NOT to use SSL

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

Need Help

2 Replies

  • haimroman's avatar
    haimroman
    New Member
    7 years ago

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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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