Forum Discussion
Solved
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 h...
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.
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
Super User
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.