Forum Discussion
Incremental Refresh - RangeEnd in Microsoft document question
Assuming you have yearly partitions your values should be
RangeStart <= value < RangeEnd
Partition RangeStart RangeEnd 2004 2004-01-01 2005-01-01 2005 2005-01-01 2026-01-01 ... ... ... 2021 2021-01-01 2022-01-01 2022 2022-01-01 2023-01-01 2023 2023-01-01 2024-01-01 You can bootstrap these partitions for example with ALM Toolkit and then fill them independently.
Thanks lbendlin. But still I didnt get what Should I give,
We have sales data from 1/1/2004 which need to be reported. Our orders can be changed to max of 1/1/2021. Before that it should be in archived partition. So 2021, 2022 and current year (2023) should do full refresh. We dont want to use Detect changes with Order_Last_updated_date.
So what should be my RangeStart and RangeEnd?
With Pro license, if one of the 2018 order is changed, what should I do to show in report?
Note: With PPU or premium, we can update that year partion which will work.
Once you publish your report with incremental refresh, the service will manage the values for RangeStart and RangeEnd. For month paritions, it use the 1st of the month to the 1st of the next month (use <, not <= for the RangeEnd comparison).
Pat