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

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Based on the refresh rules you specified in Power BI.  The service will also automatically merge partitions as needed when date boundaries are crossed (like when a new year starts).