Incremental append new rows from Table2 to Table1

[IB_rewoP]

I am new to PQ so need some assistance.

I have Table1 which have the following fields: Date, NSW Sales, QLD Sales.

Table1 is the master table in that it has entries over the last 12 months.

I have Table2, which is refreshed every day, that contain's each day's new sales for NSW and QLD.  How do I append Table2's data to Table1 in that after the append Table1 will contain all its exising sales plus the new day's sales?  I have tried the Append Query but I am unable to load to Table1 as the Append Query keeps loading to a new table and I don't want a new table created because I will need to run the Append Query every day to keep adding each new day's sales.

Thanks!

[IB_rewoP]

when I click on Close & Load To and place my cursor in Table1, I get this error message.  Looks like I can not append the new records from Table2 to Table1?

[lbendlin · Accepted solution]

Not something you can do in Excel. 

You can create a new query that says something like 

let 

   Source = Tabe1 & Table2

in

  Source

but that will ingest both tables every time you refresh. 

In Power BI proper you can use Incremental Refresh partitioning.