Keeping data after refresh

[Anonymous]

Hello communty! I really need your help.

I have four website queries with tables on them. I append these four tables into one merged table. The problem is that the data in the four original tables changes - rows can be added and deleted. So when the data on the websites is deleted, it is also deleted in the appended table every time I update the data in Power Query. I need to keep all that data in the appended table. The way I see it is that when I update the four queries each day, the data is saved to one appendedtable. Rows that have been deleted from the sources must remain in the appended table.

Any ideas how to do that?

[amitchandak]

@Anonymous , Are you doing the append of data using these DAX append method

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Anonymous]

No, I am using append in Power Query

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

I think you will have to store the original data in another place and leave it unchanged. For example my original example data is as follows, stored in excel.

After importing that data into power bi, I choose to copy the whole Sheet A and then select "Enter Data" and create Table B.

Then append Table B and Sheet A, and remove the duplicate values. 

   

So when the excel is updated (delete row2 and add row5), table B will add the new row and keep the deleted row2.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.