// troubleshooting guide · microsoft power bi
Power BI Desktop Refresh and Power Query So Slow
- Status
- Workaround available
- platforms:
- Windows (Power BI Desktop)
- updated:
- November 16, 2026
- reports:
- 3
- Method
- how we research
RUNBOOK · power-bi/desktop-refresh-slow4 FIXES
// quick answer
Slow refresh or 'Applying query changes' in Desktop is usually caused by broken query folding, auto date/time tables, wide tables and preview downloads. Turn off Auto date/time, remove unneeded columns and keep transformations foldable.
Most likely fix: Turn off Auto date/time
How to fix it
// try these in order, the most common fix is first
FIX 1Turn off Auto date/time
- 01Go to File > Options and settings > Options
- 02Under Current file select Data load
- 03Uncheck Auto date/time and use your own date table (existing date hierarchies in visuals must be repointed)
Did this fix it?FIX 2Remove columns and rows early
- 01In Power Query, remove unused columns as the first steps
- 02Filter rows at the source
- 03Avoid steps that break folding (like adding an index) before filters
Did this fix it?FIX 3Check query folding
- 01Right-click a step in Applied steps
- 02If View Native Query is greyed out, folding stopped at that step
- 03Move heavy transforms to the source or a view
Did this fix it?FIX 4Test data load settings
- 01In Options > Current file > Data load, try turning off Auto-detect new relationships
- 02Test the Allow data preview to download in the background setting both ways (Microsoft recommends background preview for many queries; forum users report the opposite helps editing lag)
Did this fix it?
SANDBOX · power-bi RUNS IN YOUR BROWSER
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on Microsoft Power BI-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
Refresh or Apply changes takes minutes, the Power Query editor lags on every step, or refresh got much slower after an update.
Why it happens
- C-01Query folding broken so the whole table is pulled and transformed locally
- C-02Auto date/time creating a hidden date table for each date column
- C-03Wide tables and unnecessary columns
- C-04Background preview downloads and auto-detect relationships
// this guide also covers
- power bi desktop refresh slow
- power query slow
- power bi applying query changes slow
- power bi refresh takes forever
Still not working?
If Microsoft Power BI keeps failing, you're not alone. See every Microsoft Power BI problem users report or the alternatives people switch to.
Done fighting Microsoft Power BI? Our small team builds your own Microsoft Power BI alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usThe same problem in other apps
All slow, laggy or resource-hungry guides →
Why Is My Tableau Dashboard So Slow? (Tableau)
Why Is Looker Studio So Slow? (Looker Studio)
Other Microsoft Power BI errors
- Power BI Scheduled Refresh Failed
- Power BI Gateway Offline or Could Not Be Reached
- Why Is My Power BI Report So Slow?
- Power BI Desktop Not Opening or Stuck on Splash Screen
- Can't Sign In to Power BI Desktop
- Power BI Visual Has Exceeded the Available Resources
- Power BI Error: The Key Didn't Match Any Rows in the Table
- Power BI DataFormat.Error: We Couldn't Convert to Number