Forum Discussion

mssq's avatar
mssq
New Member
9 years ago

How to connect to multiple excel files in blob storage

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.

 

2 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    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.