How to connect to multiple excel files in blob storage

[mssq]

I have a system that every 5 minutes writes a new excel file into blob storage that has important metrics and other results. I have manually connected to this excel file and I have created a query that transforms this data into a data model that can be used on the visualization report.

My question is how to I easily re-use my query and visualization report to load a new excel file over and over again?

Ideally I would like to have a slicer on my report page that would read the file names from blob storage and refresh the slicer and allow it to connect to the latest file.

Any help in setting something up to re-use the query and visualization report would be appreciated.

[v-yuezhe-msft]

Hi @mssq,

You can review the example in the following similar blogs to get more details about how to connect to multiple files in blob storage. You may need to define a function to load multiple Excel files after you connect to Azure Blob Storage and expand the target container.

Loading multiple JSON files using Power Query
Combining Excel files using Power Query for Excel


Thanks,
Lydia Zhang

[BhaveshPatel]

You could load the entire container (or even the next level up - what it calls the account name) as a data source. You would then able to see your individual blobs as a binary data source in the tabular view. Editing the query then allowed expanding this bringing the file content into view.