2.2.5.34 RefreshPolicy Object

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.