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.
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.