Forum Discussion

betizad's avatar
betizad
Helper I
5 years ago

Power BI Desktop issues with company proxy when using Databricks connector

I am facing issues with Power BI Desktop when trying to connect to a Databricks cluster (using either AAD or token) and read tables.   When I setup the connection on my company latop with the compa...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi betizad ,

 

Try to take the steps below:( import mode) 

Step 1: Get the JDBC server address

  1. In Azure Databricks, go to Clusters and select the cluster you want to connect to.
  2. On the cluster edit page, scroll down and select the JDBC/ODBC tab.
  3. On the JDBC/ODBC tab, copy and save the Hostname and HTTP path.

Hostname: centralus.azuredatabricks.net

HHTP Path: sql/protocolv1/o/8159029426904320/0127-082543-soar12

Step 2: Configure and make the connection in Power BI Desktop

  1. Launch Power BI Desktop, click Get Data in the toolbar, and click More…
  2. In the Get Data dialog, search for and select the Spark connector.
  3. Click Connect.
  4. On the Spark dialog, configure your cluster connection. Get Server Hostname and HTTP Path from Step 2.

Server: https://<ServerHostname>:<PORT>/<HTTPPath> 

Server example: https://centralus.azuredatabricks.net:443/sql/protocolv1/o/8159029426904320/0127-082543-soar12

Protocol: Select HTTP.

Data Connectivity mode: Select Import, which lets you offload processing to Spark. This is ideal when you have a large volume of data or when you want near real-time analysis.

Click OK.

On the next dialog, enter the word token in the User name field and a personal access token in the Password field.

Click Connect

 

Below is the related reference you may go to :

https://social.msdn.microsoft.com/Forums/en-US/a9ad2ab0-78e5-4022-b9e9-580586078803/databricks-connection-error-with-power-bi?forum=hdinsight

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

betizad's avatar
betizad
Helper I
5 years ago

Hi v-kelly-msft 

 

Thanks very much for the detailed instructions. I tried the new alternative solution with the Spark connection. Unfortunately the end result is the same. I get the smae SSL_connect error code as above. 

 

Just for testing i disconnected the VPN on the company laptop, and it goes through. I can access the tables and continue with data retrieval from either Spark or Databricks connection (via token or AAD). 

Unfortunately this can't be a solution, as the devices will be in a zone that the proxy can not be disabled or disconnected. 

 

P.S. I dont know if this helps, but our company proxy is a deep inspection proxy and it even reissues certificates.