question

Rajesh-9616 avatar image
4 Votes"
Rajesh-9616 asked AnjaliRajeevTambe-4787 commented

JDBC\ODBC connection to Azure Dataricks fails

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://docs.microsoft.com/en-us/azure/databricks/scenarios/connect-databricks-excel-python-r
https://docs.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](500593) 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





azure-databricks
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered BowyerJohnCDCDDIDNCEZIDDPEICTR-4242 commented

Hello @Rajesh-9616,

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.

33536-image.png

Step 2: Configure Azure Databricks cluster connection in Power BI

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

  2. Click Connect.

33558-image.png

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

  2. Select your Data Connectivity mode.

  3. Click OK.

33582-image.png

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

  2. 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).

  3. Click Connect.

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

33458-image.png

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.




image.png (118.4 KiB)
image.png (133.5 KiB)
image.png (62.1 KiB)
image.png (138.6 KiB)
· 23
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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."

0 Votes 0 ·

Hello @Rajesh-9616,

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?

0 Votes 0 ·
Rajesh-9616 avatar image Rajesh-9616 PRADEEPCHEEKATLA-MSFT ·

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


33949-image.png


2 Votes 2 ·
image.png (17.1 KiB)
Show more comments

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

0 Votes 0 ·

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 84444-c1331aef-3fd6-4b5d-97d9-3df6c84b6a73.jpeg


0 Votes 0 ·

Any update on this one, facing same issue

0 Votes 0 ·

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

66154-image.png


0 Votes 0 ·
image.png (30.3 KiB)

@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.

0 Votes 0 ·

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.

0 Votes 0 ·

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

0 Votes 0 ·

@PranathiPanyam-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?

0 Votes 0 ·

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?

0 Votes 0 ·

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

0 Votes 0 ·
BrianMcCully-3409 avatar image
0 Votes"
BrianMcCully-3409 answered BrianMcCully-3409 published

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LarsFiedler-4855 avatar image
0 Votes"
LarsFiedler-4855 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VenkatIndrakanti-9070 avatar image
1 Vote"
VenkatIndrakanti-9070 answered AnjaliRajeevTambe-4787 commented

I got it to work by enabling SSL, checking "Use Trusted store" and unchecking "Check Certificate Revocation"
199353-image.png



image.png (17.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

what are the steps to do this?

1 Vote 1 ·