Scheduled Refresh and Gateway
Power BI reports often depend on data that changes regularly. Scheduled refresh helps keep imported data in a semantic model up to date without requiring a user to refresh it manually every time. A data gateway can provide a secure connection between Power BI Service and supported data sources located inside a private network.
Learning Objectives
- Understand semantic model refresh in Power BI Service.
- Differentiate manual refresh from scheduled refresh.
- Understand the purpose of a data gateway.
- Identify when an on-premises data gateway is needed.
- Configure and test refresh settings.
- Troubleshoot common refresh and gateway problems.
1. What Is Data Refresh?
Data refresh updates the imported data stored in a Power BI semantic model by retrieving data from its configured source. For example, if a sales database receives new transactions each day, a refresh can bring those transactions into the semantic model so reports can display updated results.
Refreshing data does not necessarily mean that the report design changes. It usually updates the data used by the existing visuals, measures, and report pages.
2. Manual Refresh vs. Scheduled Refresh
| Feature | Manual Refresh | Scheduled Refresh |
|---|---|---|
| How it starts | A user starts a refresh when needed. | Power BI Service starts refreshes according to a configured schedule. |
| Typical use | Testing, troubleshooting, or updating data on demand. | Regular updates such as daily or weekly reporting. |
| User involvement | Requires someone to initiate the operation. | Runs automatically when the schedule and dependencies are configured correctly. |
| Monitoring | Check the result after initiating refresh. | Review refresh history and failure notifications where configured. |
3. What Is Scheduled Refresh?
Scheduled refresh allows a semantic model to refresh automatically at configured times. Before setting it up, confirm that the model's data sources are supported, credentials are valid, and any required gateway connection is available.
General Setup Procedure
- Publish the Power BI Desktop report to the appropriate workspace.
- Open Power BI Service and locate the semantic model associated with the report.
- Open the semantic model's settings.
- Review the data source credentials and connection configuration.
- Configure the gateway connection if the source requires one.
- Locate the scheduled refresh settings.
- Enable refresh and choose the available frequency and times.
- Apply the settings and check the refresh history after the scheduled run.
4. What Is a Data Gateway?
A data gateway provides a bridge between Power BI Service and supported data sources that Power BI Service cannot access directly. It is commonly used when data is stored on a local server or inside a private corporate network.
A gateway allows the service to communicate with the configured source through an approved connection. It does not replace source credentials, database permissions, or network access requirements.
5. Types of Gateway and When They Are Needed
| Gateway Option | Typical Purpose |
|---|---|
| On-premises data gateway | Connects Power BI Service to supported data sources inside a local or private network. |
| Standard mode | Supports shared gateway use across multiple users and workloads, subject to configuration and permissions. |
| Personal mode | Designed for individual use with supported Power BI refresh scenarios and has more limited sharing capabilities. |
| Direct cloud connection | Some cloud data sources can be accessed directly without an on-premises gateway, depending on the source and configuration. |
6. Installing and Configuring a Gateway
A gateway should be installed on a computer or server that can reach the required data sources and remain available during scheduled refreshes. In organizational environments, coordinate installation with the administrator responsible for infrastructure and data access.
General Configuration Workflow
- Identify the data source that Power BI Service needs to access.
- Confirm whether the source requires a gateway.
- Choose the appropriate gateway mode for the intended use.
- Install the supported gateway software on an appropriate machine.
- Sign in and register the gateway according to the setup instructions.
- Configure the data source connection and required credentials.
- Grant the required users permission to use the gateway connection.
- Map the published semantic model to the correct gateway data source.
- Test connectivity and run a refresh to confirm that the setup works.
7. Configuring Scheduled Refresh Settings
After the semantic model has valid credentials and any required gateway connection, configure its refresh schedule in Power BI Service. The options displayed depend on the source, model, capacity, and organizational settings.
| Setting | What to Review |
|---|---|
| Refresh frequency | Choose a supported schedule that meets the reporting requirement. |
| Time zone | Check the time zone used when interpreting scheduled refresh times. |
| Data source credentials | Confirm that the configured account is valid and authorized. |
| Gateway connection | Verify that the correct gateway and data source mapping are configured. |
| Refresh history | Review the status, duration, and error details of refresh attempts. |
| Notifications | Configure available failure notifications so issues can be addressed. |
8. Common Refresh and Gateway Problems
| Problem | Possible Cause | Suggested Solution |
|---|---|---|
| Scheduled refresh fails because of credentials. | The password changed, expired, or lacks the required permissions. | Update the data source credentials and test the connection. |
| Gateway appears offline. | The host computer is unavailable or gateway software is not running correctly. | Check the host, gateway service, network connectivity, and gateway status. |
| Power BI cannot find the required gateway source. | The semantic model is not mapped to the correct configured data source. | Review the gateway data source and semantic model mapping. |
| Refresh takes too long. | The source query is slow, the model is large, or the source system is under load. | Review query performance, model design, source capacity, and refresh timing. |
| Refresh works locally but fails online. | The service may have different credentials, network access, or connection settings. | Review cloud credentials, gateway requirements, and source connectivity. |
| New records do not appear in a report. | The refresh has not completed, failed, or the report uses a different data path. | Check refresh history, source data, filters, and the model configuration. |
9. Practical Exercise
Task: Configure a Refresh Plan for a Sales Report
Use a practice Power BI report connected to a data source that you are authorized to access.
- Publish the Sales Performance report to your practice workspace.
- Identify the data source used by the semantic model.
- Determine whether a gateway is required for that source.
- Review the data source credentials in Power BI Service.
- Configure a gateway connection if the source requires one.
- Set an appropriate refresh schedule using the available options.
- Run a test refresh and confirm that it completes successfully.
- Review the refresh history and record the result.
- Simulate a troubleshooting scenario by reviewing the settings that could cause a failure.
Expected outcome: A documented refresh configuration with valid source access, the correct gateway setup where needed, and a verified refresh result.
10. Knowledge Check
Question 1: What is the purpose of scheduled refresh?
A. To redesign report pages automatically
B. To update imported model data according to a configured schedule
C. To remove all report filters
D. To create a new workspace every day
Question 2: When is an on-premises data gateway commonly needed?
A. When connecting the service to a supported source inside a private network
B. Whenever a report contains a card visual
C. Whenever a report uses a blue theme
D. Only when creating a report title
Question 3: What should you check when scheduled refresh fails?
A. Only the report background color
B. Only the number of report pages
C. Credentials, gateway connectivity, source access, and refresh history
D. The desktop wallpaper
Show Answers
- B — Scheduled refresh updates imported model data at configured times.
- A — A gateway commonly provides access to supported private-network data sources.
- C — These settings help identify common refresh failures.
Summary
Scheduled refresh helps keep imported Power BI semantic model data up to date by running refresh operations at configured times. Before enabling it, verify the data source credentials, connection settings, and refresh requirements.
A data gateway provides a connection between Power BI Service and supported data sources that are not directly accessible from the service, such as sources inside a private network. The gateway must be configured correctly and available when refresh is required.
After configuring refresh, review refresh history and troubleshoot any errors involving credentials, gateway availability, connectivity, or source performance. A reliable refresh process helps reports present timely and trustworthy business information.