I referred the following links in net and tried all, but still I am not connecting to Azure Databricks database
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.
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
.
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?
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.
@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?
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?
@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?
