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 

 

I think I know where the problem might be. But I have no idea how this can be resolved setting up proxy with the internal Power BI Simba Spark ODBC Driver. A bit help is really appreciated.

 

I can setup the ODBC connection (Requires admin rights to install Simba Spark ODBC driver) with proxy settings in a new ODBC connection as below, and it works. This method also requires one new connection setup per Spark cluster. 

 

I used the configuration suggested here:

https://docs.microsoft.com/en-us/azure/databricks/scenarios/connect-databricks-excel-python-r

    • betizad's avatar
      betizad
      Helper I
      5 years ago

      Thanks v-kelly-msft . 

      Yes this method works to make a connection. But it requires two more installations (Simba ODBC driver + Gateway for Powe BI service side refresh). It also requires generating tokens and does not work with Azure AD.

      Still The proxy issue from Power BI side (to connect with internal driver) is standing. I'll try to get in touch with Microsoft support.