I am designing a flow where I would like to update a shared Excel spreadsheet. Under the existing constraints, I'll need to update a private copy and sync it to the shared location.
a workflow that is automatically scheduled to copy an excel file in a shared location in the company (NOT 365, i.e. :z:\\path\document.xlxs) to a sharepoint, or 365 locatioon that then will automatically update any powerBI dashboard ort report that is created based on it.
At the moment, I have to manually update, when the original report refreshes, then run update in Power BI