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 UserAssign RangeEnd to currentdate and RangeStart to previousdate.
Not sure which tutorials you refer to, but this one here is pretty good.
Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn
stribor45Post Prodigy
Post ProdigyBut assigning previous and current date for those values will call API endpoint and get data from April 1 to
today. How would I get data from Jan - March?
- lbendlin
The Power BI service will do that automatically during the incremental refresh, supplying the appropriate dates for each partition.