Get Data in Databricks DBFS using Power BI Desktop

[MF_BI]

Hello all,

I try to connect to the data stored in DBFS of Databricks, using the connector Azure DataBricks with the credential ODBC in Power BI :

I get this folder empty :

In Databricks I have those folders below :

There any solution to fetch this data in DataBricks ? Thank you for your help.

Best,

[soumenms2015]

@v-yanjiang-msft hello can't acces DBFS Filestore in PowerBI Desktop . Only default database from Database Tables (Databricks) is displayed in PowerBI Desktop. The above link never metion how to access DBFS FileStore . Thank you

[v-yanjiang-msft]

Hi @MF_BI ,

Before you go, make sure you have everything you need.

• Power BI Desktop 2.85.681.0 or above. 
• After Power BI Desktop starts, it will prompt you for your Databricks credentials. You can provide your Databricks user name and password, a Databricks personal access token, or sign in with Azure Active Derectory.

• An Azure Databricks cluster or Databricks SQL endpoint.

Please follow the document Connect Power BI Desktop to a Databricks cluster which introduces the steps in details.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.