Forum Discussion
Incremental refresh not overwriting parameters
I'm probably using the wrong terminology. When I created the RangeStart and RangeEnd parameters, I used 6/1/2018 for RangeStart and 6/5/2018 for RangeEnd. All of the documentation I've been able to find seems to suggest that it doesn't matter what you put in as the default because once you publish and refresh in Power BI Service, it will refer to the incremental refresh policy to overwrite the default for those parameters and will pull in all of the data that you select to keep (in my case, 4 years) and on subsequent refreshes will refresh what you select to refresh (in my case 5 days).
When I publish and refresh, only those five days from my default parameter filter are there. In the dataset management area, under "Parameters" it shows my default dates and allows me to change them. In other posts, it seems like this should be disabled.
It is giving me neither the 4-year history nor the latest 5 days update. Are you saying that I need to manually adjust the parameters each day to the last 5 days? It would give me the latest 5 days, but I still wouldn't have the 4-yr history, right?
After you set up the parameters and did your "Apply and Close". Did you right click on the tables in the Field Picker and select "Incremental Refresh"? Also just to double check, did you upload this into a Workspace that has premium assigned to it (the diamond symbol)?
- Yes to both.
This was the method I used, perhaps you can give it a test.
This is the line immediately after the Source line:
#"Incremental Refresh" = Table.SelectRows(Source, each [Period Start Date] >= RangeStart and [Period Start Date] < RangeEnd),
Naturally you'd need to change "Period Start Date" to your date field.
My table uses a date key instead of a date/time date, so I had to convert. This is my filter step:
= Table.SelectRows(#"Source", each [REQUESTED_DATE_KEY] >= Date.Year(RangeStart)*10000+Date.Month(RangeStart)*100+Date.Day(RangeStart) and [REQUESTED_DATE_KEY] < Date.Year(RangeEnd)*10000+Date.Month(RangeEnd)*100+Date.Day(RangeEnd))
It seems to be the same as what you suggested but with the conversion. I am able to get to the Incremental Refresh screen. I publish it, refresh it, and it is still filtered to the 5 days that I used as defaults in the RangeStart and RangeEnd parameters.