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
