I have a table, say, "ExistingData" that has data from January till May (pulled in from an excel workbook). Now, I have data for the month of June in an Excel workbook (say "NewData.xls"), which I want to append to the ExistingData. Using the Append query function helps me do this, but only once.
I need to be able to do this every month, by hitting refresh. (The new data will be saved in the same path).
Combining 2 excel files is not exactly what I am looking for. I need a way to add new rows to my ExistingData every month, when I hit refresh in PowerBI Desktop. The source excel workbook "NewData" would only include rows for the current month, while the collection/accumulation of all data for previous months would be in the "ExistingData" table in powerBI.
So, essentially I need a method to append data to the master table, while retaining existing data in there. All this without having to go in to query editor everytime and append it.