Adding New Rows to table every month

[arjun2506]

Hello

here is what I am trying to do: 

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

Is there a way to do this?

[parry2k · Accepted solution]

@arjun2506 did you looke at the video provided in that post, combining in that is appending excel files.

[Ashish_Mathur · Accepted solution]

Hi,

See the video at this link - https://www.youtube.com/watch?v=yL11ugShdrk.

[parry2k]

@arjun2506there are many blogs/posts on combining excel files, here is similar post which can help.

[arjun2506]

Hello @parry2k , thanks for the reply.

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.

Is there a way to do this?

[sreejaphirose]

Hi @arjun2506 did you find a way to do this?

[parry2k · Accepted solution]

@arjun2506 did you looke at the video provided in that post, combining in that is appending excel files.