Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago

Incremental Refresh

I am trying to test incremental refresh and in my power query i have data from January 1 2024 until today.  I also  have set up  parameters (RangeStart and RangeEnd) to be between April 1 - April 9. ...
Need Help
Tips and Tricks
stribor45's avatar
stribor45
Post Prodigy
2 years ago

I almost just about finished. I was wondering how to make this RangeEnd parameter to always be the current todays date

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Why would that be necessary?  It will mess with the meta data and reset the incremental refresh

     

    Set RangeEnd to a date in the future.

    • stribor45's avatar
      stribor45
      Post Prodigy
      2 years ago

      because I always have to hard-code today's date (see image in the previous post). 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        You don't need to do that. The parameter values in Power Query have nothing to do with the actual partition boundaries in Incremental Refresh.  Think of them as a way for you (the report developer) to only use the necessary subset of data for development work.  Again - these values will be ignored/overwritten by the Power BI service.

         

        Use a future date and then leave it be.