// troubleshooting guide · microsoft power bi

Why Is My Power BI Report So Slow?

Status
Workaround available
platforms:
Power BI Desktop, Power BI service
updated:
November 16, 2026
reports:
4
Method
how we research
Share

RUNBOOK · power-bi/report-slow5 FIXES

// quick answer

Slow Power BI reports usually come from one or two heavy visuals, complex DAX measures or DirectQuery to a slow source. Use Performance Analyzer to find the slow visual, then simplify the page, the measure or the model.

Most likely fix: Find the slow visual with Performance Analyzer

How to fix it

// try these in order, the most common fix is first

  1. FIX 1Find the slow visual with Performance Analyzer

    1. 01In Power BI Desktop select the Optimize ribbon > Performance Analyzer (in the service: Edit > View > Performance Analyzer)
    2. 02Select Start recording, then Refresh visuals
    3. 03Expand the slowest visual and compare DAX query, Direct query, Visual display and Other times
    Did this fix it?
  2. FIX 2Fix slow DAX

    1. 01Select Copy query on the slow visual
    2. 02Run it in DAX query view to test changes
    3. 03Replace heavy iterators and FILTER over whole tables with simpler measures
    Did this fix it?
  3. FIX 3Reduce visuals per page

    1. 01Keep the key visuals on the main page
    2. 02Move detail into drillthrough pages or tooltips
    3. 03Replace many cards with one multi-row card
    Did this fix it?
  4. FIX 4Slim the model

    1. 01Remove unused columns in Power Query
    2. 02Split Date/Time columns into Date and Time to cut cardinality
    3. 03Turn off Auto date/time in File > Options and settings > Options > Current file > Data load and use one date table
    Did this fix it?
  5. FIX 5Speed up DirectQuery

    1. 01If the DirectQuery time is high, optimize the source query or indexes
    2. 02Consider Import or composite models with aggregations
    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

Pages take many seconds to load, slicers lag, visuals show spinning dots, or the report is fast in Desktop but slow in the service.

Why it happens

  • C-01Too many visuals on one page
  • C-02Complex DAX measures with heavy iterators
  • C-03DirectQuery to a slow database
  • C-04Large, wide model with high-cardinality columns
  • C-05Custom visuals that render slowly

// this guide also covers

  • why is power bi so slow
  • power bi report slow
  • power bi slow loading
  • power bi performance analyzer
  • power bi dashboard slow

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 →