2.2.5.34 RefreshPolicy Object

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.