Scheduled data refresh in Power BI - Step-by-Step Guide

Introduction

Scheduled data refresh lets your Power BI reports update automatically with the latest data. This saves you from manually refreshing and keeps your dashboards current.

When your sales report needs to show daily updated numbers without manual effort

When you want your marketing dashboard to reflect the latest campaign data every morning

When your finance team requires weekly updated budget reports automatically

When you have data sources that change regularly and want your visuals to stay accurate

When you share reports with others and want them to see fresh data without delays

Steps

Step 1: Sign in

- Power BI Service (app.powerbi.com)

You see your workspace and reports dashboard

Step 2: Select

- Workspace containing your dataset

Workspace content list appears showing reports and datasets

Step 3: Click

- Datasets tab or section

List of datasets appears

Step 4: Click the ellipsis (three dots) next to your dataset

- Dataset name

A menu opens with options

Step 5: Select

- Settings from the menu

Dataset settings page opens

Step 6: Click

- Scheduled refresh section

Scheduled refresh options appear

Step 7: Turn on

- Keep your data up to date toggle

Scheduled refresh is enabled

Step 8: Set

- Refresh frequency and time slots

Refresh schedule is configured

Step 9: Click

- Apply or Save button

Your scheduled refresh settings are saved

Before vs After

Before

Dataset refresh is manual; report shows data from last manual update, e.g., yesterday's sales

After

Dataset refresh runs automatically at set times; report shows today's updated sales data without manual action

Settings Reference

Keep your data up to date

📍 Dataset settings > Scheduled refresh

Enable or disable automatic data refresh

Default: Off

Refresh frequency

📍 Dataset settings > Scheduled refresh

Choose how often the dataset refreshes

Default: Daily

Time slots

📍 Dataset settings > Scheduled refresh

Set the exact time(s) when refresh happens

Default: One time slot

Credentials

📍 Dataset settings > Data source credentials

Provide access to data source for refresh

Default: Depends on data source

Common Mistakes

Not setting data source credentials in dataset settings

Without valid credentials, scheduled refresh will fail and data won't update

Go to Data source credentials in dataset settings and enter correct login details

Setting refresh frequency more than allowed by your Power BI license

Power BI limits refreshes per day based on license; exceeding causes refresh failures

Check your license limits and schedule refreshes within allowed frequency

Ignoring refresh failure notifications

Failures mean data is stale; ignoring them causes outdated reports

Regularly check refresh history and fix errors promptly

Summary

Scheduled data refresh keeps your Power BI reports updated automatically.

You set refresh frequency and time in dataset settings on Power BI Service.

Remember to provide valid data source credentials and respect license limits.

Practice

1. What is the main purpose of scheduled data refresh in Power BI?

easy

A. To create new reports from scratch

B. To manually refresh data only when the user clicks refresh

C. To automatically update reports with the latest data at set times

D. To delete old data from the dataset

Solution

1. Step 1: Understand scheduled refresh concept

   Scheduled data refresh means Power BI updates data automatically without manual action.

2. Step 2: Identify the purpose in Power BI context

   This automatic update keeps reports current by refreshing data at set times.

3. Final Answer:

   To automatically update reports with the latest data at set times -> Option C

4. Quick Check:

   Scheduled refresh = automatic update [OK]

Hint: Scheduled refresh means automatic updates, not manual [OK]

Common Mistakes:

• Confusing scheduled refresh with manual refresh
• Thinking it creates new reports
• Assuming it deletes data

2. Which of the following is the correct place to set the scheduled refresh frequency in Power BI?

easy

A. In Power BI Service under Dataset settings

B. In Power BI Desktop under File > Options

C. In the data source system outside Power BI

D. In the Power BI mobile app settings

Solution

1. Step 1: Identify where refresh settings are configured

   Scheduled refresh frequency is set in Power BI Service, not Desktop or mobile app.

2. Step 2: Locate the exact setting

   It is found under Dataset settings in Power BI Service where you configure refresh times.

3. Final Answer:

   In Power BI Service under Dataset settings -> Option A

4. Quick Check:

   Refresh frequency set in Service Dataset settings [OK]

Hint: Set refresh schedule in Power BI Service, not Desktop [OK]

Common Mistakes:

• Trying to set refresh in Power BI Desktop
• Looking in mobile app settings
• Assuming data source controls refresh schedule

3. Consider this scenario: You set a scheduled refresh for your dataset at 2 AM daily. The data source requires a gateway. What will happen if the gateway is offline at 2 AM?

medium

A. The refresh will succeed using cached data

B. The refresh will run but only partially update data

C. Power BI will automatically switch to a backup gateway

D. The refresh will fail and the dataset will not update

Solution

1. Step 1: Understand gateway role in scheduled refresh

   Gateway connects Power BI Service to on-premises data sources for refresh.

2. Step 2: Analyze effect of gateway being offline

   If gateway is offline, Power BI cannot access data source, so refresh fails and no update occurs.

3. Final Answer:

   The refresh will fail and the dataset will not update -> Option D

4. Quick Check:

   Offline gateway causes refresh failure [OK]

Hint: Gateway offline means refresh fails, no update [OK]

Common Mistakes:

• Assuming refresh uses cached data when gateway is offline
• Thinking Power BI auto-switches gateways
• Believing partial data updates happen

4. You configured scheduled refresh but it never runs. Which of the following is the most likely cause?

medium

A. The dataset credentials are invalid or expired

B. The report visuals are not published

C. The Power BI Desktop file is open on your computer

D. The refresh frequency is set to every 5 minutes

Solution

1. Step 1: Check prerequisites for scheduled refresh

   Valid credentials are required for Power BI Service to access data source during refresh.

2. Step 2: Identify why refresh might not run

   If credentials are invalid or expired, refresh cannot authenticate and will not run.

3. Final Answer:

   The dataset credentials are invalid or expired -> Option A

4. Quick Check:

   Invalid credentials block refresh [OK]

Hint: Always verify dataset credentials for refresh to work [OK]

Common Mistakes:

• Thinking open Desktop file blocks refresh
• Assuming report visuals affect refresh
• Believing refresh frequency too fast causes failure

5. You want to schedule a data refresh for a dataset connected to multiple data sources, some on-premises and some cloud-based. What is the best approach to ensure all data refreshes successfully?

hard

A. Only schedule refresh for cloud sources and refresh on-premises data manually

B. Use a gateway for on-premises sources and configure credentials for cloud sources in Power BI Service

C. Install multiple gateways, one for each data source type, and schedule refresh separately

D. Combine all data sources into one cloud source to avoid using gateways

Solution

1. Step 1: Understand gateway use for on-premises data

   On-premises data requires a gateway to connect Power BI Service to local data sources.

2. Step 2: Configure cloud data sources separately

   Cloud data sources do not need a gateway but require proper credentials set in Power BI Service.

3. Step 3: Combine both configurations for full refresh

   Using a gateway for on-premises and credentials for cloud sources ensures all data refreshes automatically.

4. Final Answer:

   Use a gateway for on-premises sources and configure credentials for cloud sources in Power BI Service -> Option B

5. Quick Check:

   Gateway + credentials = full scheduled refresh [OK]

Hint: Gateway for on-premises, credentials for cloud sources [OK]

Common Mistakes:

• Ignoring gateway for on-premises data
• Trying to refresh all sources manually
• Assuming one gateway covers cloud sources