I have a power automate flow setup that grabs a report that I am emailed daily and saves it to the companies sharepoint that I also have a powerbi setup to pull from. The overall goal is to prevent server bog from pulling from all these daily reports in my powerbi as eventually the query would become huge. I was thinking to setup the flow to combine andd reports into a master sheet then have a 90 day archive built that deletes any days over 90 days info from the sheet. Currently I had the flow saving to sharepoint before adding mastersheet idea, but upon that addition it broke the flow and gave runtime errors. pull excel from email-> save to sharepoint folder->grab all rows from the daily report->save to master sheet that is also located in different folder in sharepoint.
