How to Configure Power BI Report Scheduled Refresh

Having a Power BI report with outdated data is like driving with a blurry windshield - you can see the road, but you can’t trust the details. Setting up a scheduled refresh ensures your reports are always current, keeping your team informed and your decisions sharp. This guide will walk you through exactly how to configure an automatic refresh in the Power BI service, step by step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What Exactly is a Scheduled Refresh?

A scheduled refresh is an automated process within the Power BI Service that updates the data in your datasets at regular intervals. When you create a report in Power BI Desktop, you import or connect to data from various sources. Once you publish that report to the Power BI Service (the cloud-based platform), the data is essentially a snapshot from the last time you refreshed it on your desktop.

Without a scheduled refresh, you would have to manually open an updated PBIX file, hit the refresh button, and republish it every single time you wanted to see new data. This is tedious, time-consuming, and prone to human error - did someone forget to republish the report this morning?

The scheduled refresh feature solves this. You can tell Power BI: "Hey, at 8:00 AM every weekday, go get the latest data from my sales database, my CRM, and that Excel sheet, and update this report." Your dashboards and reports then automatically reflect the latest information without you lifting a finger.

Before You Start: Key Prerequisites

Before jumping into the settings, you need to have a few things in place. Getting this foundation right will save you a lot of headaches later.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Have a Power BI Pro or PPU License

Scheduled refresh is a feature of the Power BI Service, not the free Desktop application. To publish reports to a workspace, share them, and configure automated refreshes, you’ll need a Power BI Pro or Premium Per User (PPU) license for your account.

2. Publish Your Report to the Power BI Service

This might seem obvious, but your automated refresh is configured in the cloud. You must first develop your report in Power BI Desktop and publish it to a workspace in app.powerbi.com.

3. Understand Your Data Sources (Cloud vs. On-Premises)

This is the most critical step. Power BI Service needs a way to securely access your original data sources to pull in new information. How it does this depends entirely on where your data lives.

• Cloud-Based Sources: If your data is already in the cloud - like in a SharePoint Online list, an Azure SQL database, or Google Analytics - the process is relatively simple. Power BI can connect to these directly over the internet. You’ll just need to provide your login credentials once.
• On-Premises Sources: If your data is located within your company’s private network - like on a local SQL Server, a file on a shared network drive, or an Excel workbook on your computer - Power BI’s cloud service can’t reach it directly for security reasons. To solve this, you need a special piece of software called an <strong>On-premises data gateway</strong>.

Setting Up the On-Premises Data Gateway

If any of your report's data sources are on-premises, you must install and configure a data gateway first. Think of the gateway as a secure doorman that lives on a computer inside your company’s network. When Power BI Service needs fresh data, it securely sends a request to the gateway. The gateway then retrieves the data from your local source and sends it back to Power BI in the cloud, all through an encrypted channel.

Step-by-Step Gateway Installation:

1. Download the Gateway: In the Power BI Service, click the download icon in the top right corner and select "Data Gateway." You'll want the "Standard mode," as this is designed to be shared by multiple users and services.
2. Install It on an Always-On Computer: The gateway must be installed on a server or computer that is always on and connected to your company network. If the designated computer is turned off, the refresh will fail because Power BI can't reach the gateway.
3. Sign In and Register: Run the installer and sign in with your Power BI account. Then, register a new gateway on the computer. Give it a descriptive name (e.g., "Marketing Dept Gateway") and, most importantly, create and safely store the Recovery Key. You will need this key if you ever need to restore or move your gateway.
4. Confirm it's Running: Once installation is complete, you should see a confirmation that your gateway is online and ready to be used.

How to Configure Your Scheduled Refresh

Once your gateway is running (if needed) and your report is published, you’re ready to set up the schedule. The key thing to remember is that you schedule the refresh for the Dataset, not the report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Navigate to Dataset Settings

Log into the Power BI service. In your workspace, find the dataset that corresponds to your report. It will have the same name and a different icon. Click the ellipsis (...) next to the dataset name and select Settings.

Step 2: Connect to Your Gateway (If Applicable)

In the Settings menu, expand the "Gateway connection" section. If you’re using on-premises data sources, you'll see your gateway listed here. Ensure there’s a green "Online" status check. All of your on-premises sources for this dataset should automatically map to your successfully installed gateway.

Step 3: Provide Your Data Source Credentials

Every report needs permission to access the underlying data. Expand the "Data source credentials" section and click "Edit credentials" for each source listed.

• For cloud sources (like SharePoint or Salesforce), you'll often be prompted to sign in via OAuth2.
• For on-premises sources (like a local database), you'll need to enter the server details and username/password that Power BI will use to log in.

Power BI securely stores these credentials, allowing the refresh process to run without you needing to sign in every time.

Step 4: Set the Refresh Schedule

This is where the magic happens. Scroll down and expand the Scheduled refresh section.

1. Toggle the "Keep your data up to date" switch to On.
2. Refresh frequency: Choose either Daily or Weekly.
3. Time zone: Select the correct time zone for scheduling.
4. Add another time: Click this link to set specific refresh times. You are limited to the number of scheduled refreshes per day based on your license type - 8 times per day for Pro and 48 times per day for Premium.

Pro Tip: Schedule your refreshes for times of low server usage, such as overnight or very early in the morning before colleagues start their workday. This ensures that a long-running refresh doesn't slow down the system during peak hours.

Step 5: Set Up Failure Notifications

Under the time scheduler, you’ll find a checkbox for "Send refresh failure notifications to me." It’s highly recommended to leave this on. You can also specify other team members or a group email in the box below to receive alerts if something goes wrong.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 6: Apply Your Settings

Once you’re satisfied with your schedule, click the Apply button at the bottom of the screen. Your scheduled refresh is now live!

Troubleshooting Common Refresh Failures

Even with everything set up perfectly, refreshes can sometimes fail. To check on your history, go back to the dataset in your workspace, click the ellipsis (...), and choose Refresh history. This will show you a log of every refresh attempt and its status.

Here are some of the most frequent culprits for a failed refresh:

• Gateway is Offline: The computer hosting your data gateway was shut down, lost its internet connection, or the gateway service stopped running. The solution is to ensure the host machine is on and the service is active.
• Expired Credentials: A password for one of your data sources changed (e.g., your database password or your Microsoft 365 password). Simply go back into "Edit credentials" to update them to ensure a secure connection.
• Source File Moved or Renamed: If your report is pointing to a specific Excel file on a network share and someone renames or moves it, the refresh will fail because Power BI can no longer find the file at the specified path.
• Schema Changes in the Data Source: If a column used in your report was deleted or renamed in the source database or file, the Power Query script in your report will break during the refresh. You'll need to open the PBIX file in Desktop, update the relevant query steps, and republish.
• Refresh Times Out: For datasets on a Pro license, scheduled refreshes can only run for a maximum of two hours. If your dataset is huge and the refresh process takes longer than that, it will time out and fail. The solution is often to optimize your data model or Power Query transformations, or upgrade to a Premium capacity, which offers a longer, five-hour timeout.

Final Thoughts

Setting up a scheduled refresh is a fundamental skill for any Power BI user. It transforms your reports from static snapshots into dynamic, reliable sources of truth for your organization. By configuring your data source credentials, setting up a gateway for on-premises data, and choosing a consistent schedule, you can put your reporting on autopilot and focus on deriving insights, not clicking refresh.

The manual work of connecting data sources and scheduling refreshes still forms the backbone of traditional BI. We built Graphed because we believe gaining insights should be even simpler and more instantaneous. By connecting your favorite marketing and sales apps like Google Analytics, HubSpot, and Salesforce with just a few clicks, you can ask a question in plain English and get a real-time dashboard instantly. There’s no scheduling needed because your data is always live, removing one more piece of friction between you and the answers you need to grow your business with a tool like Graphed.