Create new table with Apended data

[ashwinkolte]

Hi 

Appreciate if anybody can help with this requirement 

Context : This is basically incremental load with a slight difference as mentioned below 

1) My Power BI report already has a query , lets say "Query1" which is refreshed in usual process from a couple of excel sheets as main source .

2) I want a new query "Query2" which will take whatever is in "Query1" and append to whatever is in "Query2" .

Obviously only once (For the very first time when refresh is clicked)  new "Query2" should be created which is duplicate of "Query1" . For ALL subsequent refreshes data should be appended from "Query1" to whatever is exisitng in "Query2" as mentioned above, irespective of any parameter

3) I am not using power BI service and want this functionality within Power BI desktop hence I guess the "Incremental refresh" functionality will not applicable 

4) I guess this will need a M code but any other solution is OK 

Please let me know

[MNedix]

Hi,

Have you tried this: https://community.fabric.microsoft.com/t5/Power-Query/M-to-append-queries/td-p/1169349

Best,