Forum Discussion
Solved
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 int...
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.
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
