Connect a distributed file from Azure Blob Storage to Power BI

[Anonymous]

Hi,

I have a dataset that was created using Databricks and saved in Azure Blob Storage. As this is done using a Spark cluster, the data is stored in multiple files located in a single directory. I would like to create a connection to this directory to Power BI so that all of the data is available for visualization.

It would be ideal if the connection can be created with parquet files, but csv will also do.

Can anyone tell me what would the best way to do this? Thanks in advance.

[amitchandak]

@Anonymous , see if these can help

https://www.sqlshack.com/how-to-access-data-from-azure-blob-storage-using-power-bi/

https://support.surveycto.com/hc/en-us/articles/360036528793-Integration-with-Power-BI-part-6-Using-Microsoft-Azure

[harshnathani]

Hi @Anonymous ,

See if these solutions help

https://community.powerbi.com/t5/Desktop/Reading-parquet-files-from-blob-storage/m-p/992373

https://community.powerbi.com/t5/Power-Query/Calling-Azure-Storage-Blob-in-custom-connector/m-p/1157699

https://community.powerbi.com/t5/Desktop/How-to-read-and-extract-CSV-file-in-Azure-Blob/m-p/242989

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!