Can Logic App refresh excel file in the Azure Storage (blob)?

Question

I have data source from external (KoboTool Box). This data source provides conversion to excel file (From Web connection) by put specific web link. After I got all data, I put these excel file in the Azure blob storage.

By using Logic App, I have got the file in the blob container but I have no idea how to refresh this excel file to retrieve external data. There are two Excel Online (One drive & Business). I don't know what next steps.

My question, is it possible to refresh this excel file to get the latest update data from external data source by using logic app ?

Answer 1

@MasTidar Unfortunately, as per the Excel Online (Business) or Excel Online (One Drive) there is no action that can help you retrieve external data and refresh the excel.
Excel connector does have different actions to update the excel but you need to provide the input to insert/update the excel rows and you can explore if you can get the data from the data source and use different actions to update the data in excel.

I am not an expert in excel scripting but in case if there is a way to write the script to refresh the data then you can leverage the run script action in your logic app workflow.

Answer 2

I'm after similar.
I have an excel spreadsheet linked to a Power BI Dataset and it automatically updates the dataset on opening. Unfortunately, it is held in blob storage now and will not update on access in Data Factory LookUp>

If you took it out of blob storage and put it back in, would this work?