How to Set Refresh Time in Power BI

Nothing undermines a great dashboard quicker than stale data. While Power BI is incredible for creating dynamic visualizations, its real power lies in providing timely insights you can trust. This article will show you exactly how to set up a scheduled refresh so your reports stay current automatically, delivering accurate data right when you need it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother with Scheduled Refresh?

Manually updating your Power BI reports is a tedious and forgettable task. You publish a beautiful dashboard on Monday morning, but by Wednesday, the data is already out of date. Relying on manual refreshes introduces delays and increases the risk of making decisions based on old information. When you spend hours building a report, you want it to be a source of truth, not a historical snapshot.

Setting up a scheduled refresh solves this problem by directly connecting your reports to their underlying data sources on a schedule you define. Here’s what you gain:

• Timely Decision-Making: Key stakeholders get the most current data delivered to them at a predictable time, whether it's every morning at 8 AM or once a week.
• Time Savings: You eliminate the repetitive, manual task of opening Power BI Desktop, clicking "Refresh," and republishing the report. This automation frees you up to focus on analyzing the data, not just collecting it.
• Consistency and Reliability: Automated processes run like clockwork. You remove human error and ensure that everyone is looking at the same, consistently updated information, building trust in your reports.

Understanding Power BI Refresh Types

Before we jump into the "how," it’s important to understand what is being refreshed. How Power BI handles data updates depends entirely on how you connected to your data source in the first place. There are three primary connection modes:

Import Mode

This is the most common connection type and the one that requires a scheduled refresh. When you use Import Mode, Power BI takes a copy of your data from sources like Excel files, SQL databases, or web services and loads it into your Power BI file (.pbix). The data is compressed and stored within the file itself.

Pros: Excellent performance because all the data is held in-memory.

Cons: The data is static - it's a snapshot in time and doesn't update until you manually refresh it or schedule a refresh.

This is the mode our step-by-step guide will focus on.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

DirectQuery Mode

With DirectQuery, Power BI does not import or copy the data. Instead, it maintains a live connection to the original data source. Every time a user interacts with a report (like filtering a chart or slicing data), Power BI sends a query directly to the source database to fetch the latest information.

Pros: The data is always current, making it ideal for highly volatile data sources.

Cons: Performance depends heavily on the speed of the underlying data source. Complex visuals can result in slow-loading reports.

Live Connection Mode

Live Connection is similar to DirectQuery but is specifically for connecting to a pre-built data model, typically from SQL Server Analysis Services (SSAS), Azure Analysis Services (AAS), or another Power BI dataset. It also provides a live link, ensuring visualizations reflect the latest data in the model.

For the rest of this guide, we'll assume you are using Import Mode, as it's the scenario that requires you to actively set up a refresh schedule in the Power BI Service.

Prerequisites: What You Need First

Before you can automate your data updates, you'll need a few things in place:

• A Power BI Pro or Premium License: The scheduled refresh feature is not available on the free Power BI license. You and any users consuming the reports will generally need a Pro license, or the workspace must be backed by a Premium capacity.
• A Published Report: Scheduled refresh is configured in the Power BI Service (the cloud version), not in Power BI Desktop. You must have already published your report from the Desktop app to a workspace online.
• An On-Premises Data Gateway (If Needed): If your data source is "on-premises" (meaning it lives on a local computer or a server within your company's network, like an Excel file on your C: drive or a local SQL Server), you'll need a gateway. The gateway acts as a secure bridge, allowing the cloud-based Power BI Service to connect to and pull data from your private, on-premises sources. If all your data sources are in the cloud (e.g., SharePoint Online, Azure SQL), you won't need the gateway.

How to Schedule Your Automatic Refresh: A Step-by-Step Guide

Ready to automate? Follow these steps to set up your schedule in the Power BI Service.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Navigate to Your Dataset

Log into the Power BI Service (app.powerbi.com). In the left-hand navigation pane, find the workspace where you published your report. Don't click on the report itself, instead, find the corresponding dataset. It will have the same name as your report and an orange icon. Click the three dots (...) next to the dataset name and select Settings.

Step 2: Provide Data Source Credentials

In the Settings screen, you'll see several sections. Expand the Data source credentials section. Power BI needs to know how to log in to your data sources on its own. For each source listed, click "Edit credentials" and provide the necessary authentication information (like a username/password for a database or an OAuth2 connection for a cloud service). You must do this for Power BI to access the data without your direct intervention.

Step 3: Configure Your On-Premises Gateway

If you're using on-premises data sources, you'll see a Gateway connection section. If your gateway is set up correctly, you’ll see it listed with a green "Running" status. Ensure your data sources are mapped to a corresponding source created in the gateway configuration. If this area shows an error, you'll need to troubleshoot the gateway on the machine where it’s installed before proceeding.

Step 4: Turn On and Configure Scheduled Refresh

This is where the magic happens. A bit further down, you will see the Scheduled refresh section. Click the toggle to turn it on. This will reveal several configuration options:

• Refresh frequency: Choose either Daily or Weekly.
• Time zone: Select your local time zone to ensure the refresh happens at the correct local time.
• Time: Click "Add another time" to specify the exact time of day you want the refresh to run.

Be aware of your license limitations. A Power BI Pro license allows for up to 8 refreshes per day per dataset. A Power BI Premium license allows for up to 48 refreshes per day.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Set Up Refresh Failure Notifications

Under the time selection, you'll find an option to "Send refresh failure notifications." By default, these emails go to you, the dataset owner. You can also add other team members or IT contacts who should be alerted if the automated refresh fails for any reason (e.g., a data source is down or credentials have expired).

Step 6: Apply Your Settings

Once you've configured your schedule and notifications, click the Apply button at the top or bottom of the screen. And that’s it! Your refresh is now scheduled. You can trigger a manual refresh from this same set of menus by clicking “Refresh Now” if you need to update the data outside of your schedule.

Quick Tips and Troubleshooting

Setting up your schedule is usually straightforward, but here are a few best practices and common issues to keep in mind.

• Stagger Your Refresh Times: If you have multiple reports, avoid scheduling them all to refresh at the same time, like 8:00 AM. Staggering them by 15 or 30 minutes can reduce the load on your data sources and gateway.
• Check Your Refresh History: In the dataset menu (where you hovered to click "Settings"), you'll also see an option for Refresh history. This screen shows you a log of every scheduled and on-demand refresh, whether it succeeded or failed, and the error reason if it broke. This is your first stop for troubleshooting.
• Common Failure Reasons: The most frequent causes of failed refreshes are expired data source credentials (many systems require password changes every 90 days), the gateway machine being turned off or losing internet connection, or changes to the underlying data source (like a renamed file or a changed column header).
• Mind the Timeout Window: By default, Power BI will try to refresh your data for two hours before timing out. If you have a very large and complex data model, you may need a Premium capacity, which lets you extend this window up to five hours.

Final Thoughts

Setting up a scheduled refresh in Power BI elevates your reports from static documents to reliable, dynamic decision-making tools. By following these steps, you can ensure your data is always current, save yourself countless hours of manual work, and build unshakable confidence in the insights your reports provide.

Power BI is an excellent and powerful tool, but the setup process for things like on-premises gateways can still feel complex and technical. We built Graphed to simplify this entire experience. By connecting your cloud data sources - like Google Analytics, Shopify, and Salesforce - in just a few clicks, you get real-time dashboards that update automatically, with no refresh schedules or gateways to configure. You can build entire dashboards just by describing what you want to see, freeing you to focus on discovering insights instead of wrangling data connections.