Hi everyone,
I am completely stumped at how to accomplish the following, and I hope I can get some insight here:
Objective:
- I have an Excel Online document that is a current copy of an SQL Server database report export.
- Every night the SQL database updates its' report to include new records from that day
- I need to be able to schedule a flow that checks for new records in the SQL database and updates the Excel document with just the new rows.
Issues:
- My experience with Power Automate is decidedly limited and so far all I've managed to accomplish is getting the flow to constantly add the entire database to the document in a loop - which inflates the filesize in an absurd way and ultimately fails
- I had originally intended to simply connect the database to the Excel file and leave it to refresh within Excel Online, but alas, it isn't supported.
- I also had another idea to pull the table into Power BI, and then push that out to an Excel export into Sharepoint/Onedrive, but doing that on a schedule appears to be another flow that I am not familiar enough to build.
I realize I'm asking a lot as far as info/guidance goes with this, but is a total blocker for a larger project until I can solve for it. I need to be able to have an XLSX in Excel Online for other workplace functions to read from, which has been a challenge.
Any assistance anyone might be able to offer here would be immensely appreciated!
