Forum Discussion
Incremental Refresh: RangeStart and RangeEnd set-up
Hello all:
I have Pro license and tried to set up Incremental Refresh for my data-set- As it is available per Feb updates.
My sales data is from 01/01/2018 onwards- Understnad the RangeStart and RangeEnd will be automatically updated after refresh, I still set up as below dates first:
However, when i tried to input "RangeStart and RangeEnd " values in "Custom Filter" for sales dates, I found I can't...
It asked me to enter specific dates!
Not sure what should I do now? Hence ask for advice.
13 Replies
Anonymous , refer if this can help https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
- Hi there
What happens if you click on the arrow drop down which should bring up the calendar picker?- I think you might be getting a bit confused.
The parameters are to be created to be only really used when the dataset is uploaded to the Power BI Service. And then when the dataset is refreshed with the incremental refresh policy it will then inject the required parameters into the RangeStart and RangeEnd.
All you need to do is to have anything in there before uploading to the Power BI Service. It will be overwritten once the incremental refresh starts
Hi,
Please try to check your parameter type whether is 'Date' or not:
Best Regards,
Giotto Zhi
- It needs to be set as DateTime to work correctly.
