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
7 years ago

Hi and thanks for your answer.

I had read that link before my post, but it did not enlighten me :)


Let's explain what is hard for me to understand...

In one of my report, I want to show data from 2017 to now, and I want to refresh only the last 3 months.

So I have set up incremental refresh in this report, RangeStart value to the first of april and RangeEnd to the first of july, for example. But applying those parameters in the Power Query editor delete data before RangeStart in the report.


So how can I show the data before the RangeStart if this data is absent from the report ?

collinq's avatar
collinq
Super User
5 years ago

Hey FXFelix ,

 

In this sections of that link (https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#refresh-ranges) the article explains how to keep the older data.  Also, if this isn't working the way you expect, you can get everything ready for incremental refresh and then run the report so that all the data you expect comes in and THEN turn on incremental refresh and from then on it will keep adding the data you need.