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
betizad's avatar
betizad
Helper I
5 years ago

Hi v-kelly-msft ,

 

Thanks for the reply. I have tried with both options, and the results is the same.

 

Eventualy we would like to use "import". 

Do you know which ODBC driver is used by Power BI and how can I set the proxy there?  

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