Scheduled data refresh in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the refresh frequency to daily in Power BI service.

Power BI

Refresh settings frequency = "[1]"

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

Ahourly

Bweekly

Cmonthly

Ddaily

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'weekly' when daily updates are needed.

Using 'hourly' which may not be supported in all Power BI plans.

Setting the refresh frequency to "daily" ensures your dataset updates every day automatically.

2fill in blank

medium

Complete the code to specify the time zone for scheduled refresh to UTC.

Power BI

Time zone setting = "[1]"

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

APST

BUTC

CEST

DCET

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting a local time zone instead of UTC.

Confusing EST with UTC.

UTC is the Coordinated Universal Time, commonly used for scheduling to avoid confusion across time zones.

3fill in blank

hard

Fix the error in the refresh schedule expression to enable refresh only on weekdays.

Power BI

Refresh days = [1]

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

A["Monday", "Tuesday", "Wednesday", "Thursday", "Friday"]

B["Saturday", "Sunday"]

C["Monday", "Sunday"]

D["Friday", "Saturday"]

Attempts:

3 left

💡 Hint

Common Mistakes

Including weekend days in the refresh schedule.

Selecting only one weekday.

Weekdays are Monday through Friday, so the refresh should be scheduled on these days only.

4fill in blank

hard

Fill both blanks to configure the refresh start time and frequency correctly.

Power BI

Refresh configuration = {"start_time": "[1]", "frequency": "[2]"}

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

A02:00

Bdaily

Cweekly

D15:00

Attempts:

3 left

💡 Hint

Common Mistakes

Setting start time in the afternoon when early morning is preferred.

Choosing weekly frequency when daily is needed.

The refresh starts at 2 AM and runs daily to keep data updated every day.

5fill in blank

hard

Fill all three blanks to create a refresh policy with start time, frequency, and retry count.

Power BI

Refresh policy = {"start_time": "[1]", "frequency": "[2]", "retry_count": [3]

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

A03:30

Bdaily

C3

Dweekly

Attempts:

3 left

💡 Hint

Common Mistakes

Using weekly frequency when daily is required.

Setting retry count too high or zero.

The policy sets refresh at 3:30 AM daily with 3 retry attempts if refresh fails.