How to import data from a file in Databricks' DBFS system into Power BI

[vamri]

I have a multiple files in Azure Databricks' DBFS file system and I want to read them into Power BI desktop. I have tried Partner Connect, Azure Databricks Connector and Spark Connector and all of these only allow me to retrieve data from the "Database Tables" file system. Any ideas on how I could solve my issue?

[vamri · Accepted solution]

Thank you @v-yanjiang-msft. I tried using Azure databricks connector but faced a similar issue. I was able to solve the problem using Data lake gen 2 connector.

[v-yanjiang-msft]

Hi @vamri ,

Please see if this document helps: Power BI - Azure Databricks | Microsoft Docs

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.