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.

      • stribor45's avatar
        stribor45
        Post Prodigy
        2 years ago

        How does the report and service them what data to pull?