2.2.5.34 RefreshPolicy Object

Article
05/14/2024

The RefreshPolicy object represents the policy used for refreshing a table’s data. It is a child of a Table object and requires compatibility level 1450 or higher.<87>

The RefreshPolicy object has the following properties. 

Name	Type	Description
ID	unsignedLong	A reference to the object.
TableID	unsignedLong	An ID-based reference to a Table object.
PolicyType	enumeration	A value that specifies the type of the refresh policy. The possible values are as follows: Basic (0) – Basic refresh policy.
RollingWindowGranularity	enumeration	A value that indicates the granularity of the rolling window for the whole data set. The possible values are as follows: Invalid (-1) – Invalid granularity. Day (0) – Day granularity. Month (1) – Month granularity. Quarter (2) – Quarter granularity. Year (3) – Year granularity.
RollingWindowPeriods	int	The number of periods for the rolling window for the whole data set.
IncrementalGranularity	enumeration	A value that indicates the granularity of the most recent incremental refresh range. The possible values are as follows: Invalid (-1) – Invalid granularity. Day (0) – Day granularity. Month (1) – Month granularity. Quarter (2) – Quarter granularity. Year (3) – Year granularity.
IncrementalPeriods	int	The number of periods for the incremental refresh range.
IncrementalPeriodsOffset	int	The lag or leading periods from Now() to the rolling window head.
PollingExpression	string	The M expression that is evaluated and stored for each partition upon each refresh or merge operation.
SourceExpression	string	The M expression that is used as the source M expression for new partitions. It includes the date filter by referring to two M parameters named [RangeStart] and [RangeEnd].
Mode	enumeration	A value that defines the mode of the refresh policy applied during incremental refresh. The possible values are as follows: Import (0) – Creates import partitions during incremental refresh. Hybrid (1) – Creates import and DirectQuery partitions during incremental refresh. Compatibility level 1565 or higher is required.