Forum Discussion
Incremental Refresh - RangeEnd in Microsoft document question
In Microsoft documentation, RangeEnd param sample given as 12/31/2022 12:00:00 AM.
Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn
If the intent to keep until end of the year, should it be 12/31/2022 11:59:59 PM?
Are we not missing 31st day sale in this example??
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.
7 Replies
Good question , but no.
One of the main rules of incremental refresh is that one of the two parameters must be inclusive and the other must be exclusive. Usually RangeStart is inclusive and RangeEnd is exclusive.
That means RangeEnd is actually the RangeStart of the next partition.
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
