Forum Discussion
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. ...
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.
How does the report and service them what data to pull?
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).
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.