Power BI data refresh stops working when credentials fail, refresh schedules break, source connections change, gateways fail, privacy settings block access, or query/model errors interrupt the refresh process.
This usually appears as:
Old data showing in reports
Refresh button not working
Refresh failed errors
Dataset not updating
Scheduled refresh failing
Visuals showing outdated numbers
Why is Power BI data not refreshing?
Common causes:
- Broken data source connection
- Expired credentials
- Power BI Gateway issues
- Refresh schedule failure
- Query errors in Power Query
- Privacy level conflicts
- Dataset size or timeout issues
- File path changed
- Source permissions removed
- Cache problems
What does data refresh do in Power BI?
Data refresh updates your report or dataset with the latest information from the connected source.
Example:
Excel → Power BI
SQL Database → Power BI
Google Sheets → Power BI
API → Power BI
When refresh runs:
- Power BI reconnects to source
- Pulls latest data
- Updates model
- Refreshes report visuals
Without refresh:
Reports show stale data
Why is Power BI showing old data?
Most common cause:
- Refresh never completed
Example:
You updated Excel source file:
Sales = ₹15,00,000
But report still shows:
Sales = ₹12,00,000
Problem:
Dataset did not refresh
Fix:
Go to:
Home → Refresh
Or in Power BI Service:
Workspace → Dataset → Refresh Now
Why is the Refresh button not working?
Possible causes:
- Internet issue
- Source disconnected
- Query error
- File moved or renamed
Example:
Excel file moved from:
C:\Sales\Data.xlsx
to:
D:\Reports\Data.xlsx
Power BI still searches old location.
Fix:
Update source path:
Transform Data → Data Source Settings
Reconnect source.
Why is Power BI scheduled refresh failing?
Common causes:
- Credentials expired
- Gateway offline
- Refresh disabled
- Source permissions changed
Problem example:
Scheduled refresh runs:
8:00 AM daily
But dataset never updates.
Fix:
Go to:
Power BI Service → Dataset Settings → Scheduled Refresh
Check:
- Refresh enabled
- Correct credentials
- Gateway connected
Why am I getting credential errors during refresh?
Most common cause:
- Authentication expired
Error examples:
Invalid credentials
Access denied
Failed to authenticate
Fix:
Go to:
Settings → Data Source Credentials
Sign in again.
Especially common for:
- Google Sheets
- SharePoint
- APIs
- SQL databases
- Excel on OneDrive
Why is Power BI Gateway causing refresh issues?
Problem:
Gateway offline or disconnected.
Typical symptom:
Refresh works in Desktop
Refresh fails in Service
Reason:
Power BI Service cannot access local files
Example:
Desktop source:
Local Excel file
SQL server on office machine
Fix:
Install and check:
On-premises Data Gateway
Verify:
Gateway Status = Online
Why is Power Query breaking refresh?
Problem:
Power Query step error.
Example:
Column renamed in source.
Before:
Revenue
After:
Sales Revenue
Refresh fails because query expects:
Revenue
Fix:
Go to:
Transform Data
Check steps with:
Error icon
Fix broken transformations.
Why is Power BI refresh stuck or very slow?
Common causes:
- Huge dataset
- Too many transformations
- Slow source
- Poor query optimization
Bad practice:
Refreshing millions of rows unnecessarily
Better:
Use:
Incremental refresh
Or:
Filter unnecessary data
Example:
Instead of:
2010–2026 sales history
Load:
Last 12 months
when possible.
Why is Power BI data refresh failing after file rename?
Problem:
Source path changed.
Example:
Old file:
Financial_Model.xlsx
Renamed to:
Finance_Model_Final.xlsx
Power BI cannot find source.
Fix:
Go to:
Data Source Settings
Reconnect file.
Why is Power BI refresh failing in Service but working in Desktop?
Most common cause:
- Gateway issue
- Unsupported local source
- Credential mismatch
Example:
Works here:
Power BI Desktop
Fails here:
Power BI Service
Fix checklist:
- Check gateway online
- Re-enter credentials
- Verify permissions
- Confirm source accessibility
Why are visuals not updating after refresh?
Possible causes:
- Dataset not refreshed
- Cached visuals
- Filters applied
- Wrong dataset connected
Fix:
Try:
Refresh visuals
Then verify:
Model data updated
Also check report filters.
Why is Power BI data refresh timing out?
Problem:
Refresh takes too long.
Common causes:
- Large dataset
- Slow SQL query
- Complex Power Query logic
Fix:
- Reduce rows loaded
- Optimize queries
- Remove unnecessary columns
- Use incremental refresh
Power BI refresh errors and fixes
| Problem | Fix |
|---|---|
| Old data | Refresh dataset |
| Credential error | Re-login credentials |
| Gateway offline | Restart gateway |
| Refresh timeout | Reduce dataset size |
| Query error | Fix Power Query step |
| File moved | Update source path |
| Scheduled refresh failed | Reconfigure refresh |
Best practices for Power BI refresh
- Keep source credentials updated
- Avoid unnecessary transformations
- Use incremental refresh for large models
- Check gateway health regularly
- Reduce dataset size where possible
- Verify source paths after file changes
- Test refresh after schema changes
FAQs
Why is Power BI not refreshing data?
Usually because of credential failures, gateway issues, query errors, or broken source connections.
Why does Power BI show old data?
The dataset refresh likely failed or never ran.
Why is refresh working in Desktop but not Service?
Usually due to gateway or credential issues.
Why is scheduled refresh failing?
Expired credentials, offline gateway, or disabled refresh settings are common causes.
Why is Power BI refresh so slow?
Large datasets, inefficient queries, or too many transformations often slow refresh.
How do I force refresh in Power BI?
Go to:
Home → Refresh
or:
Power BI Service → Refresh Now