// 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
Share

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

  1. FIX 1Turn off Auto date/time

    1. 01Go to File > Options and settings > Options
    2. 02Under Current file select Data load
    3. 03Uncheck Auto date/time and use your own date table (existing date hierarchies in visuals must be repointed)
    Did this fix it?
  2. FIX 2Remove columns and rows early

    1. 01In Power Query, remove unused columns as the first steps
    2. 02Filter rows at the source
    3. 03Avoid steps that break folding (like adding an index) before filters
    Did this fix it?
  3. FIX 3Check query folding

    1. 01Right-click a step in Applied steps
    2. 02If View Native Query is greyed out, folding stopped at that step
    3. 03Move heavy transforms to the source or a view
    Did this fix it?
  4. FIX 4Test data load settings

    1. 01In Options > Current file > Data load, try turning off Auto-detect new relationships
    2. 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 us

Watch Microsoft Power BI Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

The same problem in other apps

All slow, laggy or resource-hungry guides →

Other Microsoft Power BI errors

All 14 Microsoft Power BI errors and fixes →