This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 25 | |
| 24 | |
| 15 |
| User | Count |
|---|---|
| 62 | |
| 48 | |
| 27 | |
| 21 | |
| 20 |