Forum Discussion

Marc-Alexis's avatar
Marc-Alexis
Frequent Visitor
6 years ago
Solved

Incremental refresh - Alternate RangeStart and RangeEnd

Dear PBI gurus,   I am currently implementing a model with the incremental refresh functionality.   The issue I am facing is that one of the tables would require alternate RangeStart and RangeEnd...
Need Help
  • Marc-Alexis's avatar
    Marc-Alexis
    6 years ago

    Hello Lionel,

     

    Thank you for your answer. Actually, whilst it is indeed impossible to set alternate RangeStart nor RangeEnd, it is possible at a later stage to change different archive and refresh periods by table.

     

     

    I will confirm when fully implemented

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Marc-Alexis ,

 

No, It's impossible to achieve the idea in current version( 2.81.5831.821 64-bit (May 2020)).

But you don't need to set two sets of parameters.

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • Marc-Alexis's avatar
    Marc-Alexis
    Frequent Visitor
    6 years ago

    Hello Lionel,

     

    Thank you for your answer. Actually, whilst it is indeed impossible to set alternate RangeStart nor RangeEnd, it is possible at a later stage to change different archive and refresh periods by table.

     

     

    I will confirm when fully implemented

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It is possible to modify RangeStart and RangeEnd using functions in Power Query (checkout guyinacubes latest youtube video for how to implement this)