Forum Discussion
Incremental append new rows from Table2 to Table1
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!
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.
2 Replies
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?
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.
