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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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?
@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.
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.
@numersoz , You have already tried the step mentioned here?
https://community.powerbi.com/t5/Issues/Cannot-connect-to-Azure-Databricks/idi-p/1728652
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 45 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 108 | |
| 108 | |
| 39 | |
| 33 | |
| 25 |