How to Refresh Dataflow in Power BI

Keeping your Power BI reports accurate means keeping your underlying data fresh. If you use Power BI dataflows to centralize and reuse your data, you need a reliable way to make sure they're updated regularly. In this quick tutorial, we’ll walk you through how to refresh your dataflows, both manually for on-the-spot updates and automatically with a schedule so you can set it and forget it.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Power BI Dataflow?

Before diving into the "how," let's quickly clarify the "what." A Power BI dataflow is a self-contained, cloud-based process for preparing data. You use the familiar Power Query experience to connect to data sources, clean up the data, and transform it. That collection of transformed data, called a table (or entity), is then stored in Azure Data Lake Storage Gen2 within your Power BI environment. The magic of dataflows is that they are reusable. You can create one master "Customer" dataflow, for instance, and connect it to dozens of different Power BI datasets and reports. This centralizes your data logic, ensuring consistency across your analytics. If you need to change how "Customer" data is calculated, you only have to update it in one place: the dataflow. But this powerful feature is only useful if the data in the dataflow is current. An outdated dataflow means every report depending on it will also be outdated.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Manually Refresh a Power BI Dataflow

A manual refresh is perfect for when you need the most up-to-the-minute data right now, or when you’re testing changes you just made to the dataflow. It’s an on-demand process that you trigger yourself. Here’s how to do it step-by-step:

1. Navigate to Your Workspace: Log into the Power BI Service (app.powerbi.com) and go to the workspace that contains your dataflow. Workspaces are the collaborative spaces where you and your team store reports, dashboards, datasets, and dataflows.
2. Find Your Dataflow: In the list of workspace items, find your dataflow. You can use the filter at the top to display only dataflows if the list is long.
3. Trigger the Refresh: Hover your mouse over the dataflow's name. You will see a small set of icons appear to the right. Click the circular arrow icon, which is the Refresh now button.

That's it! Power BI will immediately begin the refresh process. You'll see a small spinning icon next to the "Last refresh" time, indicating that it's in progress. Depending on the size of your data and the complexity of your transformations, this could take anywhere from a few seconds to many minutes. You can check the progress and success of the refresh by looking at the "Refresh history," which we'll cover later in the troubleshooting section.

How to Set Up a Scheduled Refresh for Your Dataflow

Manually refreshing works, but it isn't scalable. The real power comes from automating the process so your data is always up-to-date without any human intervention. This is where a scheduled refresh comes in. You can configure Power BI to refresh your dataflow at specific times every day. Keep in mind that the number of scheduled refreshes you can set depends on your license. A Power BI Pro user can schedule up to 8 refreshes per day, while a Premium (Per User or Per Capacity) user can schedule up to 48 refreshes per day.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step-by-Step Guide to Scheduling a Refresh

Follow these steps to set up your automatic refresh schedule:

1. Configure Your Data Sources

Before you can schedule a refresh, you need to make sure Power BI can access your data sources on its own.

• In your workspace, find your dataflow, click the three-dot menu (...), and select Settings.
• Under the settings, you’ll see sections for Gateway connection and Data source credentials.
• Gateway Connection: If your dataflow pulls from an on-premises data source (like a local SQL Server or an Excel file on a network drive), you must have an on-premises data gateway installed and running. In this section, make sure your gateway is selected and mapped correctly.
• Data Source Credentials: Here, Power BI needs to know how to log in to your data sources. Click Edit credentials for each data source. You'll need to provide the necessary authentication, whether it’s a username/password for a database or signing in with your account for a cloud service like Shopify or Salesforce (using OAuth2). This allows the Power BI service to securely connect and pull a fresh copy of your data without you having to be there.

2. Build Your Schedule

Once your credentials are set, you’re ready to schedule the refreshes.

• In the same settings menu, scroll down to the Scheduled refresh section.
• Click the toggle to turn scheduled refreshing On.
• Refresh frequency: Choose whether you want the refresh to happen Daily or Weekly. Most businesses use daily.
• Time zone: Select your operational time zone. This is crucial for making sure "8 AM" means your 8 AM, not UTC.
• Add Time: Click Add another time to specify the times you want the refresh to run. Enter the hours and minutes (e.g., 08:00 for 8 AM). You can add multiple time slots up to your license limit. A good practice is to schedule refreshes for early in the morning before the business day starts, and perhaps once during lunch.
• Set Up Failure Notifications: Life happens, and sometimes refreshes fail. Check the box under Send refresh failure notifications to to get an email if something goes wrong. You can also add other stakeholders, like members of your data team, so the right people are alerted immediately.
• Apply the Changes: Click the Apply button at the bottom of the page to save your schedule.

Your dataflow will now refresh automatically according to the schedule you’ve created, ensuring your reports are powered by consistently updated information.

Checking Refresh History and Troubleshooting Failures

Setting up a schedule is only half the battle. You also need a way to verify that refreshes are completing successfully. The Refresh history tool is your command center for this.

How to View Your Refresh History

1. Go to your workspace and find the dataflow.
2. Click the three-dot menu (...) and select Refresh history.

This will open a panel showing a log of all recent refresh attempts. You will see key information for each attempt:

• Start Time: When the refresh process began.
• Type: Whether it was triggered manually (On-demand) or by the schedule (Scheduled).
• Duration: How long the refresh took to complete.
• Status: The most important column. This will show Completed or Failed.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Common Causes of Refresh Failures

If you see a "Failed" status, don't worry. It's usually due to a handful of common issues. Here are the most frequent culprits and how to fix them:

• Expired Credentials: This is the number one cause. Database passwords change, or the authorization token for a cloud app expires. Power BI will then be unable to log in. The fix: Go back to the dataflow Settings, find the "Data source credentials" section, and re-enter your new credentials.
• Gateway is Offline: If you use an on-premises gateway, the machine it's installed on might be turned off or have lost internet connectivity. The fix: Ensure the machine hosting the gateway is on and connected to the internet. You can also check the status of the gateway service on that machine.
• Schema Changes at the Source: The structure of your source data may have changed. For example, a developer renamed a column in the SQL database that your dataflow relies on. When your Power Query steps try to find the old column name, the refresh fails. The fix: You need to edit the dataflow itself. Open the Power Query editor for your dataflow and update your transformation steps to match the new schema of the source data.
• Query Timed Out: The query is taking too long to execute and Power BI gives up. This often happens with very large dataflows or inefficient transformations. The fix: Try to optimize your Power Query transformations. Filter data earlier in your steps, remove unnecessary columns, and look into options like incremental refresh for Premium users to only process newly changed data.

By regularly checking your refresh history, especially after first setting up a schedule, you can catch and resolve these issues quickly before they impact business decisions.

Final Thoughts

Maintaining fresh, reliable data is the foundation of any successful analytics strategy. Properly refreshing your Power BI dataflows - either manually for instant updates or through a robust schedule for automation - ensures that every report and analysis you build on top of them reflects the current state of your business. The daily struggle of keeping data current across all your platforms is something we understand deeply. Before any analysis can happen, you first have to wrangle data from Google Analytics, Salesforce, Facebook Ads, and a dozen other tools, often by manually pulling CSVs every Monday morning. We built Graphed because we wanted to eliminate that friction. By connecting your tools to our platform, your dashboards refresh automatically in real-time. This means you’re always looking at live data without ever having to set up a refresh schedule or worry if your reports are out of date.