Power BI Data flow Incremental refresh not working as the way I want it.

[Zack92]

Hi,
I need some help figuring out what I'm doing wrong.

The issue is that every time I schedule an Incremental Refresh, it’s replacing the existing data instead of just adding new data.

I’ve set up Incremental Refresh for a small data set, and the settings are below. The data set doesn’t have any historical data, so my plan is to use Incremental Refresh to capture the weekly snapshots going forward. I’ve scheduled it to refresh every Sunday.

What I have is now below, 

What I’m really aiming for is something like this: (below screenshot). Is there something I’m doing wrong, or is there a better way to approach this? Could it be an issue with how I’ve set things up?

Thank you 

[lbendlin]

so my plan is to use Incremental Refresh to capture the weekly snapshots going forward

That's not what Incremental Refresh does.  Power BI has no memory, you need to manage your snapshots further upstream or in Fabric.

[Zack92]

@lbendlinI thought if I set it up in a dataflow, it would save the data. Can you please let me know how to do that in Fabric? I have a Premium Per User license. Thank you so much 

[lbendlin]

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn

Manual Settings ... Append