Forum Discussion
briguin
Helper I
5 years agoIncremental Refresh - Can you change parameters and repull data
I created a dashboard with an incremental refresh and have published it to the service. My data query contains the parameters SQLStart_Dt and SQLStart_End independent of the RangeStart (8/1...
- 5 years ago
I wanted to do 2 or 3 partial data refreshes to slowly build up a historical dataset, slowly increasing the rangestart and rangeend until the full dataset had been pulled.
After testing and doing, I realized that the RangeStart and RangeEnd were finalized in the initial upload to the service. Once they were set and published they could not be changed. No matter how my other date parameters changed the newest incoming incremental data would only be in the time horizon established in the Incremental settings of how many days to go back.
lbendlin
Super User
5 years agoYou must use RangeStart and RangeEnd in your Power Query code. Your other parameters will be ignored.