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. ...
Assign 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
But 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?
The Power BI service will do that automatically during the incremental refresh, supplying the appropriate dates for each partition.