Connecting to Databricks with passthrough enabled

[Shapiran]

Hi,

I would like to connect to databricks, but would like to use passthrough, hence get my user permissions in the data lake.

I'm connected using Spark connector - https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi.

I can connect but when trying to get data from the data lake I'm getting the following error message:

Could not find ADLS Gen1 Token.

To my understanding the connector not supporting passthrough credential - https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/jdbc-odbc-bi.

Is therea way to connect to Databricks from Power BI using credentials passthrough?

Thanks,

Nir

[v-lili6-msft]

hi  @Shapiran 

You may take a look at this document:

https://docs.microsoft.com/en-us/azure/databricks/security/credential-passthrough/adls-passthrough#i...

Regards,

Lin

[Shapiran]

Thanks Lin,

Power BI is not mentioned in the doument.

One of the limitation that is mentioned is:

The following features are not supported with Azure Data Lake Storage credential passthrough:

• ...
• Connecting to your cluster using JDBC/ODBC.

To my understanding the spark connector is based on JDBC/ODBC.

I'll appriciate if you can find a solution to connect Power BI to Databricks when passthrough is enabled (as mentioned in the document you sent).

Thanks,

Nir