set_incremental_refresh
Configure incremental refresh for a Power BI table by creating a rolling-window policy and RangeStart/RangeEnd parameters, refreshing only recent data. Supports day, month, quarter, or year granularity.
Instructions
Attach a basic incremental-refresh policy to a table: keep a rolling window of data and only refresh the most recent increment. Needs RangeStart/RangeEnd M parameters - this creates them if absent (then point the table's M partition at them to bind the date range). Granularity = Day | Month | Quarter | Year.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| sessionId | Yes | ||
| pollingExpression | No | optional DAX polling expression to detect changes (real-time / hybrid) | |
| incrementalPeriods | Yes | how many recent incremental periods to refresh each run | |
| rollingWindowPeriods | Yes | how many rolling-window periods of history to keep | |
| incrementalGranularity | Yes | incremental granularity: Day | Month | Quarter | Year | |
| rollingWindowGranularity | Yes | rolling-window granularity: Day | Month | Quarter | Year |