// 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
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
FIX 1Find the slow visual with Performance Analyzer
- 01In Power BI Desktop select the Optimize ribbon > Performance Analyzer (in the service: Edit > View > Performance Analyzer)
- 02Select Start recording, then Refresh visuals
- 03Expand the slowest visual and compare DAX query, Direct query, Visual display and Other times
Did this fix it?FIX 2Fix slow DAX
- 01Select Copy query on the slow visual
- 02Run it in DAX query view to test changes
- 03Replace heavy iterators and FILTER over whole tables with simpler measures
Did this fix it?FIX 3Reduce visuals per page
- 01Keep the key visuals on the main page
- 02Move detail into drillthrough pages or tooltips
- 03Replace many cards with one multi-row card
Did this fix it?FIX 4Slim the model
- 01Remove unused columns in Power Query
- 02Split Date/Time columns into Date and Time to cut cardinality
- 03Turn off Auto date/time in File > Options and settings > Options > Current file > Data load and use one date table
Did this fix it?FIX 5Speed up DirectQuery
- 01If the DirectQuery time is high, optimize the source query or indexes
- 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 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
- Power BI Desktop Refresh and Power Query 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