Append Difference on refresh instead of replace

[Corey_M]

I have a dataflow containing record for computers with various information and it refreshes every day.  occasionally fields get updated for existing assets as well as new records for new assets.

the goal is that I have a new dataflow that when one particular field (configuration item) gets updated for an existing asset that instead of replacing the existing record it appends it.

example:

Asset	Configuration Item	Date Added
A	123	5/15/2024
B	456	5/15/2024

if asset A's configuration item is updated to 234 when the table Refreshes the next day it should look like

Asset	Configuration Item	Date Added
A	123	5/15/2024
B	456	5/15/2024
A	234	5/16/2024

[audreygerred · Accepted solution]

If your source allows query folding, you can set up incremental refresh based on the Date Added and just have the incremental refresh do 1 day. Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn