Scheduled data refresh in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants a sales dashboard that always shows the latest data without manual updates.

📊 Data: You have a sales dataset with daily transactions including Date, Product, Region, and Sales Amount.

🎯 Deliverable: Set up a scheduled data refresh in Power BI so the sales dashboard updates automatically every day.

Sample Data

Date	Product	Region	Sales Amount
2024-06-01	Widget A	North	150
2024-06-01	Widget B	South	200
2024-06-02	Widget A	East	180
2024-06-02	Widget C	West	220
2024-06-03	Widget B	North	170
2024-06-03	Widget C	South	210
2024-06-04	Widget A	East	190
2024-06-04	Widget B	West	230

1

Step 1: Open your Power BI Desktop file with the sales data loaded.

No formula needed.

Expected Result

Your sales data is ready in Power BI.

2

Step 2: Publish the Power BI report to the Power BI Service (app.powerbi.com).

Use the 'Publish' button in Power BI Desktop and select your workspace.

Expected Result

Report is uploaded and visible in your Power BI workspace online.

3

Step 3: Go to the Power BI Service, open the workspace, and find your dataset.

No formula needed.

Expected Result

You see your dataset listed under 'Datasets + dataflows'.

4

Step 4: Click on the '...' (More options) next to the dataset and select 'Settings'.

No formula needed.

Expected Result

Settings page for the dataset opens.

5

Step 5: Under 'Scheduled refresh', turn on 'Keep your data up to date'.

No formula needed.

Expected Result

Scheduled refresh option is enabled.

6

Step 6: Set the refresh frequency to 'Daily' and choose the preferred time for refresh (e.g., 2:00 AM).

No formula needed.

Expected Result

Dataset will refresh automatically every day at the set time.

7

Step 7: If your data source requires credentials, enter them under 'Data source credentials' and test connection.

No formula needed.

Expected Result

Credentials are saved and connection test is successful.

8

Step 8: Save the settings and verify the next refresh time is scheduled.

No formula needed.

Expected Result

Next refresh time is shown confirming the schedule.

9

Step 9: Check your dashboard after the scheduled refresh time to see updated data automatically.

No formula needed.

Expected Result

Dashboard shows the latest sales data without manual update.

Final Result

-----------------------------------------
|           Sales Dashboard              |
|---------------------------------------|
| Date       | Product  | Region | Sales|
|------------|----------|--------|------|
| 2024-06-04 | Widget B | West   | 230  |
| 2024-06-04 | Widget A | East   | 190  |
| ...        | ...      | ...    | ...  |
|                                       |
| Data refresh: Daily at 2:00 AM        |
-----------------------------------------

✓Sales data updates automatically every day.

✓No manual refresh needed to see latest sales.

✓Dashboard always shows current sales figures.

Bonus Challenge

Set up email notifications to alert you if the scheduled refresh fails.

Show Hint

In Power BI Service, under dataset settings, configure 'Failure notifications' to send emails on refresh errors.