Incremental refresh in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define the range start parameter for incremental refresh.

Power BI

let RangeStart = [1]

Drag options to blanks, or click blank then click option'

ADateTimeZone.UtcNow()

BDateTimeZone.FixedUtcNow()

CDateTime.LocalNow()

DDateTimeZone.Now()

Attempts:

3 left

💡 Hint

Common Mistakes

Using local time functions instead of UTC.

Using dynamic functions that change on refresh.

The DateTimeZone.FixedUtcNow() function returns a fixed UTC datetime value used as the range start for incremental refresh in Power BI.

2fill in blank

medium

Complete the code to define the range end parameter for incremental refresh.

Power BI

let RangeEnd = [1]

Drag options to blanks, or click blank then click option'

ADateTime.LocalNow()

BDateTimeZone.UtcNow()

CDateTimeZone.FixedUtcNow()

DDateTimeZone.Now()

Attempts:

3 left

💡 Hint

Common Mistakes

Using dynamic or local time functions for RangeEnd.

Mixing local and UTC time functions.

The RangeEnd parameter uses DateTimeZone.FixedUtcNow() to set a fixed UTC datetime for the end of the incremental refresh range.

3fill in blank

hard

Fix the error in the filter expression for incremental refresh.

Power BI

Table.SelectRows(Source, each [Date] >= [1] and [Date] < RangeEnd)

Drag options to blanks, or click blank then click option'

ARangeStart

BRangeEnd

CDateTimeZone.FixedUtcNow()

DDateTimeZone.UtcNow()

Attempts:

3 left

💡 Hint

Common Mistakes

Using RangeEnd instead of RangeStart in the filter.

Using a function call instead of the parameter.

The filter should compare the [Date] column to the RangeStart parameter to define the start of the incremental refresh period.

4fill in blank

hard

Fill both blanks to complete the M query filter for incremental refresh.

Power BI

Table.SelectRows(Source, each [Date] >= [1] and [Date] [2] RangeEnd)

Drag options to blanks, or click blank then click option'

ARangeStart

B>=

C<

DRangeEnd

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong comparison operators.

Swapping RangeStart and RangeEnd.

The filter selects rows where the date is greater than or equal to RangeStart and less than RangeEnd.

5fill in blank

hard

Fill all three blanks to complete the incremental refresh filter with parameters.

Power BI

let
  Source = Sql.Database("Server", "Database"),
  FilteredRows = Table.SelectRows(Source, each [Date] [1] [2] and [Date] [3] RangeEnd)
in
  FilteredRows

Drag options to blanks, or click blank then click option'

A>=

BRangeStart

C<

DRangeEnd

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong operators like <= or >.

Mixing up RangeStart and RangeEnd.

The filter selects rows where the date is greater than or equal to RangeStart and less than RangeEnd, which is required for incremental refresh.