Forum Discussion
Incremental Refresh with Limited Data
I have a data like 20 millions for 3 year. My requirment is , I would like to load 1 month data in the desktop for development and also needs to implement incremental refresh. I have a Date fi...
Yes, that is standard functionality. You can define values for RangeStart and RangeEnd in the Power Query parameters dialogue that limit your development date range. These values have no impact whatsoever (*) on the actual implementation of incremental refresh (which is controlled by the retention and refrehs periods).
*) well, sort of. Whenever you re-publish the pbix file the users will briefly see data for your dev date range until the regular incremental refresh completes again.