Forum Discussion

MF_BI's avatar
MF_BI
Regular Visitor
4 years ago

Get Data in Databricks DBFS using Power BI Desktop

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,

 

 

 

Data Protection
Need Help
Tutorial Requests

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.

  • soumenms2015's avatar
    soumenms2015
    New Member
    4 years ago

    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