Forum Discussion

FXFelix's avatar
FXFelix
Resolver I
7 years ago

Incremental Refresh misunderstanding ?

Hi,   Please apologize for my newbie question, but I think there is something I misunderstand in the functionality "Incremental refresh".   I thought the aim of incremental refresh was to store f...
Need Help
FXFelix's avatar
FXFelix
Resolver I
5 years ago

Thanks for your answer, but unfortunately I still not understand.

If you "get everything ready for incremental refresh", then the data is filtered between RangeStart and RangeEnd in PowerQuery, and obviously the data before RangeStart and after RangeEnd are deleted from the dataset...

 

I think I'm missing a step, but I don't know which 🤔

Maybe you have to set to RangeStart a value inferior to the oldest value in your dataset, and to RangeEnd a future value, for example 31/12/2050 ?

collinq's avatar
collinq
Super User
5 years ago

Hey FXFelix ,

What I was suggesting is that you run the refresh without incremental.  That way you have everything you need.  And then, after you have all the details in the dataset you can set up the incremental refresh and that will refresh only the data for the range that you are looking to incrementally add/refresh and the old data will still be there.  Basically - get everything that you want/need the first time.  Then, use incremental refresh to add to it over time.