Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ykannan
Helper I
Helper I

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

 

 

ykannan_0-1680193662757.png

 

1 ACCEPTED SOLUTION

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.

View solution in original post

7 REPLIES 7
lbendlin
Super User
Super User

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

Microsoft Employee

Thanks @ppm1 .

 

Please confirm, with Pro license can we use ALM toolkit to update archived partition without XMLA end point?

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

Please confirm, with Pro license can we use ALM toolkit to update archived partition?

No. ALM Toolkit doesn't have that option.  You need to use an XMLA tool like Tabular Editor, SSMS, or Powershell.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.