Forum Discussion
Incremental refresh not overwriting parameters
I set everything up with a filter step converting our date key but when I publish it, it doesn't overwrite the default RangeStart and RangeEnd parameters. The data in Power BI service ends up filtered to the default.
This is what I used for the conversion/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))
10 Replies
HI anita9,
If you mean preview feature incremental refresh which based on query parameters, it not support dynamic overwriting parameter, you need to manually modify them.
Incremental refresh in Power BI Premium
Override effective date
We plan to allow setting the current date for a refresh operation. This will be useful to use with datasets like Adventure Works that don't have data up to the current date, and for testing purposes.BTW, you can also add filter in query edit and manually modify formula to achieve dynamic filters based on lastdate or local date.
Regards,
Xiaoxin Sheng
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?
