Why is Power BI Not Refreshing?
You’ve meticulously designed a Power BI report, wrangled your data with Power Query, and published it for your team to use. But when you check it the next morning, the data is stale. The scheduled refresh failed, and now you’re stuck digging through settings to figure out why. This guide will walk you through the most common reasons your Power BI refresh is failing and provide clear, actionable steps to get your reports updating automatically again.
Understanding the Two Refresh Environments: Desktop vs. Service
Before diving into troubleshooting, it's essential to understand the distinction between refreshing in Power BI Desktop and Power BI Service. This difference is often the root cause of many refresh issues.
- Power BI Desktop Refresh: When you hit the refresh button in the desktop application, your computer uses its own resources and your current user credentials to connect directly to the data sources. This process is great for building and testing your report.
- Power BI Service (Cloud) Refresh: When you set up a scheduled refresh online, the cloud-based Power BI Service needs to connect to your data sources. Unlike your desktop, it doesn't have direct access to your local files or private networks. It requires specific credentials and often a gateway to bridge the gap.
Pinpointing where the refresh fails (Desktop or Service) is your first major clue. If it works on your desktop but not in the service, the problem is almost always related to the connection between the cloud and your data source.
Common Reasons for Refresh Failures in Power BI Desktop
If you can't even get your data to refresh manually in the PBIX file, start your troubleshooting here. These problems must be fixed before you even think about publishing.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
1. Expired or Incorrect Data Source Credentials
This is easily the most frequent issue. Passwords change, security tokens expire, and access permissions get updated. Power BI stores the credentials you use to connect to each data source, and if they're no longer valid, the connection will fail.
How to Fix It:
- In Power BI Desktop, go to File > Options and settings > Data source settings.
- A list of all data sources used in your report will appear. Select the problematic data source from the list.
- Click "Edit Permissions" and then click the "Edit" button next to Credentials.
- Sign in with your updated credentials. For databases, this might be your username and password, for web services, you might need to re-authenticate via OAuth.
- Click "OK" and then "Close," and try refreshing your data again.
2. Changes in the Data Source Schema
Power Query is very particular about structure. If someone changes a column name, deletes a column, or renames a table in the source data (like an Excel file or SQL database), your Power Query steps will break because they are looking for the old structure.
How to Fix It:
- Click on "Transform data" in the home ribbon to open the Power Query Editor.
- On the left, look for the query that's causing an error (it will likely have a yellow warning icon).
- On the right, step through your "Applied Steps." The step where the error occurs will be marked.
- Analyze the error message. It will often tell you something specific, like "The column '[Old Column Name]' of the table wasn't found."
- You'll either need to update your query steps to account for the new schema or ask your data administrator to revert the changes to the source file.
3. Firewall, VPN, or Network Access Issues
Your computer needs a clear path to the data source. If you're trying to connect to a company database, you might need to be on the company VPN. A corporate firewall could also be blocking Power BI's access.
How to Fix It:
- Make sure you are connected to the correct network or VPN.
- If you suspect a firewall issue, contact your IT department. They may need to create a specific rule to allow access for Power BI.
Troubleshooting Scheduled Refresh Failures in Power BI Service
If your report refreshes perfectly in Desktop but fails on a schedule in the Service, the issue is almost certainly related to the gateway, cloud credentials, or refresh timeouts.
1. On-Premises Data Gateway is Offline or Misconfigured
For data sources that are not publicly accessible on the internet (like a local SQL Server or a file on a shared network drive), Power BI Service needs a bridge to reach them. This bridge is the On-Premises Data Gateway.
The gateway is software you install on a computer that is always on and has access to your data sources. If that computer is turned off, asleep, or loses internet connectivity, the gateway goes offline, and the refresh will fail.
How to Fix It:
- In Power BI Service, click the settings gear icon in the top right and select "Manage connections and gateways."
- Select the "On-premises data gateways" tab.
- Find your gateway in the list and check its status. If it’s offline, you need to troubleshoot the machine it's installed on. Ensure the machine is powered on, connected to the internet, and the gateway service is running.
2. Gateway Data Source Credentials Have Expired
This is a critical point that trips up many users. The credentials you saved in Power BI Desktop are not the same as the ones used by the gateway in the Power BI Service. You have to configure them separately.
How to Fix It:
- In Power BI Service, go to the workspace containing your report.
- Find your dataset (it will have the same name as your report) and click the three dots (...), then select "Settings."
- Expand the "Data source credentials" section. You will likely see an error message here.
- Click the "Edit credentials" link next to the data source that's failing.
- Provide the current credentials. This ensures the gateway has permission to access the data on behalf of Power BI service.
This same process applies to cloud-based data sources that don't need a gateway. You'll still need to re-authenticate them directly from the dataset settings page.
3. The Refresh Timed Out
Power BI has limits on how long a refresh can run. For datasets in a Pro workspace, the limit is 2 hours. For Premium workspaces, it’s 5 hours. If your data import and transformation is too complex, it can exceed this limit and fail.
How to Fix It:
- Optimize Your Power Query: The most effective solution. Go back into the Power Query Editor and make your transformations more efficient. Remove unnecessary columns early, filter data at the source if possible (don't pull in 10 years of data if you only need one), and be mindful of complex merge or append operations.
- Try Incremental Refresh: For very large datasets, set up an incremental refresh. This allows Power BI to only refresh new or changed data, rather than re-importing the entire dataset every time, dramatically reducing refresh times.
- Upgrade Capacity: If your dataset is truly massive and already optimized, the final option is to move to a Power BI Premium capacity, which provides more resources and longer timeout limits.
Free PDF Guide
AI for Data Analysis Crash Course
Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.
Check the Refresh History for Clues
Power BI Service keeps a log of all refresh attempts, which contains valuable error messages.
In your dataset settings, click on "Refresh history." Here you can see a list of scheduled and on-demand refreshes and their status (Completed, Failed). If a refresh failed, there will often be a specific error code or message that can point you directly to the problem, such as "Invalid credentials" or "Gateway is not reachable."
Final Thoughts
Fixing a broken Power BI refresh almost always comes down to systematically checking your credentials, data sources, and gateways. By methodically identifying whether the issue lies in your desktop file or in the cloud service connection, you can quickly narrow down the cause and apply the right fix to get your data flowing automatically again.
While mastering these troubleshooting steps is a valuable skill, we know firsthand that dealing with broken refresh schedules and gateway errors isn't why you started using analytics in the first place. At Graphed, our goal is to eliminate this friction entirely. We handle all the data connections, pipelines, and refreshes behind the scenes. You just connect your sources once, then use simple, natural language to get the marketing and sales dashboards you need. Since your dashboards have a live connection to your data, they're always up-to-date, letting you focus on insights, not IT tickets.
Related Articles
Facebook Ads for Dentists: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for dentists in 2026. Discover proven strategies, targeting tips, and ROI benchmarks to attract more patients to your dental practice.
Facebook Ads for Gyms: The Complete 2026 Strategy Guide
Master Facebook advertising for your gym in 2026. Learn the proven 6-section framework, targeting strategies, and ad formats that drive memberships.
Facebook Ads for Home Cleaners: The Complete 2026 Strategy Guide
Learn how to run Facebook ads for home cleaners in 2026. Discover the best ad formats, targeting strategies, and budgeting tips to generate more leads.