DataBricks SSL Certificate Error

[numersoz]

Hi,

I'm trying to connect to SQL Endpoint of DataBricks cluster with PowerBI.

I'm getting the following error:

Details: "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed."

I've installed DataBricks ODBC driver. There I was also getting SSL certificate error when testing the connection. I was able to make it work by enabling SLL certificate and editting the certificate pem file of the driver by appending Zscaler certificate (VPN). 

However, still no luck with PowerBI. 

Any recommendations?

[numersoz]

@amitchandak thank you but I've tried that and it doesn't work for me.

Below works for me and ODBC driver passes the test. I've appended the pem file in the screenshot with Zscalar certificate to make this work.

But even though ODBC driver works, PowerBI gives me this error. I found out that PowerBI has its own ODBC driver folder under the installation file. There is a pem file as well. I've appended that too, but still no luck.

[Anonymous]

Hi @numersoz, 

Where you able to solve this problem?
I have done the exect same as you with the same outcome, and not sure where to go from here. 

[amitchandak]

@numersoz , You have already tried the step mentioned here?

https://community.powerbi.com/t5/Issues/Cannot-connect-to-Azure-Databricks/idi-p/1728652