Forum Discussion
Connecting to Databricks with passthrough enabled
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
2 Replies
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
