Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adding New Rows to table every month

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?

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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?

      • parry2k's avatar
        parry2k
        Super User
        7 years ago

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