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

MasTidar 41 Reputation points
2021-11-29T05:53:03.75+00:00

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.

153214-image-2021-11-29-125005.png

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.
153178-image.png

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

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,264 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,698 questions
0 comments No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 66,341 Reputation points
    2021-11-29T10:15:17.31+00:00

    @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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Mark Northcott 1 Reputation point
    2022-10-26T06:30:20.127+00:00

    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?

    0 comments No comments