JDBC\ODBC connection to Azure Dataricks fails

Rajesh 36

Hi,

I referred the following links in net and tried all, but still I am not connecting to Azure Databricks database

https://docs.databricks.com/integrations/bi/power-bi.html
https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html
https://learn.microsoft.com/en-us/azure/databricks/scenarios/connect-databricks-excel-python-r
https://learn.microsoft.com/en-us/azure/databricks/kb/bi/jdbc-odbc-troubleshooting
https://www.sqlshack.com/connect-azure-databricks-data-to-power-bi-desktop/
https://medium.com/@mauridb/powerbi-and-azure-databricks-193e3dc567a

I am getting the below errors

Trying from DBVisualizer getting the below error
[Simba][SparkJDBCDriver] Communication link failure. Failed to connect to server. Reason: HTTP Response code: 401, Error message: Unknown.

Trying from Postman getting the below error
javax.servlet.ServletException: org.apache.thrift.transport.TTransportException

When testing the ODBC connection during System DSN setup getting the below error
[Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.

Trying from MS Power BI getting the below error
"ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct."

Any help would be appreciated

4 answers

Venkat Indrakanti 11 Reputation points

2022-05-05T18:25:35.117+00:00

I got it to work by enabling SSL, checking "Use Trusted store" and unchecking "Check Certificate Revocation"
Please sign in to rate this answer.

2 people found this answer helpful.
Anjali Rajeev Tambe 15 Reputation points

2022-07-19T14:06:34.697+00:00

what are the steps to do this?

Winegard, MacGregor 0 Reputation points

2023-02-20T17:29:06.7833333+00:00

How did you get to this screen?

Venkat Indrakanti 11 Reputation points

2023-02-21T02:44:37.88+00:00

By clicking on the SSL options

Venkat Indrakanti 11 Reputation points

2023-02-21T02:45:12.0166667+00:00
Sign in to comment
Lars Fiedler 6 Reputation points

2022-03-30T15:27:35.753+00:00

These are the instructions that usually work for us:
https://blog.composable.ai/2022/03/30/configuring-databricks-odbc-connection-in-composable/
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment
PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2020-10-20T07:50:12.363+00:00
Hello @Rajesh ,

Welcome to Microsoft Q&A platform.

Note: JDBC or ODBC driver is not required to install on your local machine.

Make sure you have followed the steps mentioned in the document.

Here are the steps to connect Azure Databricks using Power BI Desktop.

Step 1: Get Azure Databricks connection information.

Go to Clusters => Configuration => Advanced Options => JDBC/ODBC

Copy Server Hostname & HTTP Path.

Step 2: Configure Azure Databricks cluster connection in Power BI

In PowerBI Desktop, go to Get Data > Azure and select the Azure Databricks connector.

Click Connect.

Paste the Server Hostname and HTTP Path you retrieved in Step 1.

Select your Data Connectivity mode.

Click OK.

At the authentication prompt, select the way you want to log in to Azure Databricks:

Azure Active Directory: Use your Azure account credentials. Click the Sign in button. In the sign-in dialog, enter your Azure account username (email, phone, or Skype).

Click Connect.

Select the Azure Databricks data you want to query from the Power BI Navigator

Hope this helps. Do let us know if you any further queries.

------------

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.
Rajesh 36 Reputation points

2020-10-20T12:30:30.943+00:00

@PRADEEPCHEEKATLA-MSFT

Thanks for reply.

I am now getting the error "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed."

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2020-10-21T05:31:38.78+00:00

Hello @Rajesh ,

Have you followed the above steps to connect Azure Databricks using Power BI Desktop?

Note: JDBC or ODBC driver is not required to install on your local machine.

Could you please share the screenshot which you are experiencing?

Rajesh 36 Reputation points

2020-10-21T07:55:13.37+00:00

@PRADEEPCHEEKATLA-MSFT
I followed the steps as is. But I am getting the same exception. Below is the screenshot.

HarithaMaddi-MSFT 10,131 Reputation points

2020-10-22T07:36:13.313+00:00

Hello @Rajesh ,

Are you receiving this error message while connecting Azure Databricks using Power BI Desktop or while configuring ODBC?

In case if you are receiving this error message while connecting Azure Databricks using Power BI Desktop, I would request you to clear Power BI Desktop cache.

How To Clear Cache Of Power BI Desktop?

Open Power BI Desktop - Go to File menu from Top bar and go to Options and Settings - Option - Data Load has an option to clear Power BI Desktop’s cache - Click on Clear Cache button.

It will remove the cache data.

Once cache data is removed, I would request to follow the above steps to connect Azure Databricks using Power BI Desktop.

Hope this helps. Do let us know if you any further queries.

Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

Rajesh 36 Reputation points

2020-10-22T08:08:06.287+00:00

@HarithaMaddi-MSFT

I am still facing the same issue. I tried from another machine as well.

Do we need to check any network settings or SSL certificates?

I am not sure how come its working for you? Are you trying from Azure VM?

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2020-10-22T08:19:05.533+00:00

Hello @Rajesh ,

In order to test from our end, could you please share the which type Azure VM (Windows/Linux) are you using?

Rajesh 36 Reputation points

2020-10-22T08:22:03.647+00:00

@PRADEEPCHEEKATLA-MSFT

I am testing from Windows 10 laptop, not from any VM.

I was just checking whether you guyz are using Azure VM for your testing?

PRADEEPCHEEKATLA-MSFT 77,751 Reputation points Microsoft Employee

2020-10-22T08:29:20.823+00:00

Hello @Rajesh ,

We have tested the above connection via Windows 10 laptop and not from Azure VM?

Rajesh 36 Reputation points

2020-10-22T08:41:21.613+00:00

Okay. Same here.

Is this something related to network settings or SSL certificates on local laptop?

Should we need to configure any other settings in Azure Databricks?

Artur Tolstenco 6 Reputation points

2020-11-02T22:42:59.83+00:00

Experiencing same nere... have u solved this?

Rajesh 36 Reputation points

2020-11-03T10:19:36.867+00:00

Not yet. MS support team is looking into the issue.

Singh, Vivek (NonEmp) 6 Reputation points

2021-02-10T04:44:42.913+00:00

Any update on this one, facing same issue

Singh, Vivek (NonEmp) 6 Reputation points

2021-02-10T04:46:51.497+00:00

HI @PRADEEPCHEEKATLA-MSFT i am also facing same issue, have you resolved it.

Singh, Vivek (NonEmp) 6 Reputation points

2021-02-10T05:18:19.77+00:00

@Rajesh Hi

I am also facing same issue, did you resolved it ?

ChristianB 1 Reputation point

2021-03-12T08:58:01.057+00:00

@PRADEEPCHEEKATLA-MSFT - please could you update on this. We are also facing the same issue. This is through the spark connector or through azure databricks connector.

Scott Wettstein 1 Reputation point

2021-03-17T20:59:43.137+00:00

have you received any response from microsoft yet? facing same issue. i wonder if the fact that "de-users-preview.sqlazurelabs.com" is no longer available has something to do with it.

samanth m 11 Reputation points

2021-04-05T08:44:47.177+00:00

Hi Rajesh I am also facing same issue .Did you get any solution for this issue

samanth m 11 Reputation points

2021-04-05T09:21:31.343+00:00

Hi Pradeep I have followed your steps but I am also facing similar issue .Do you have any solution for this issue we are facing

DufG_1111 1 Reputation point

2021-07-09T12:35:18.937+00:00

@PRADEEPCHEEKATLA-MSFT ; Any update on the issue? We are also still facing the same error message when following the above instructions. Thanks

Eric Dong 1 Reputation point

2021-07-13T23:07:57.087+00:00

@Pranathi Panyam_MSFT same error here, more context for your analysis, if I am using personal laptop, success! company laptop, failed.

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

Thought something about proxy setup of computer?

Pablo Boswell 1 Reputation point

2021-07-24T04:57:34.85+00:00

@PRADEEPCHEEKATLA-MSFT We are experiencing the same issue. This is a major blocker to our enterprise BI initiative

Bowyer, John (CDC/DDID/NCEZID/DPEI) (CTR) 1 Reputation point

2021-08-02T20:33:19.773+00:00

We are having same issue: Details: "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed." Is this monitored or an answer available?

Bowyer, John (CDC/DDID/NCEZID/DPEI) (CTR) 1 Reputation point

2021-08-14T00:56:21.107+00:00

Note this issue goes away if I log out z-scaler

Zaid El Hassani 0 Reputation points

2023-07-04T11:29:50.2266667+00:00

No answer for this problem till now !
Sign in to comment
Brian McCully 1 Reputation point

2022-02-17T04:46:41.693+00:00

ok everyone, stumbled on the solution in a QuikView solutions page. if using the ODBC connector, click on the SSL button at the bottom right and enable....SUCCESS!.

"ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment