Forum Discussion
stribor45
Post Prodigy
Post ProdigyIncremental 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. ...
lbendlin
Super User
Super UserYou 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.
stribor45Post Prodigy
Post ProdigyHow does the report and service them what data to pull?
- lbendlin
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).
- stribor45
Ok make sense now I think. I am curious about why when I put the filtering on some of my data is missing in power query.