Why is my Power BI report slow? A practical checklist

Slow Power BI reports usually trace back to the model, the DAX or the page design. This checklist helps you find which.

By the Seestem data team ·

Start by measuring, not guessing

Use Performance Analyzer in Power BI Desktop to see how long each visual takes to load, and how much of that is the underlying query. For deeper analysis, DAX Studio shows the queries and the work the engine does. Knowing which visuals and measures are slow turns a vague problem into a short list.

1. Check the data model

  • Use a star schema: a central fact table with clean dimension tables around it.
  • Remove columns you do not use, especially wide text columns and high-cardinality columns.
  • Use the right data types, and avoid storing values as text when they are numbers or dates.
  • Prefer single-direction relationships, and be cautious with bi-directional filtering.
  • Turn off the automatic date/time tables if you use your own date table.

2. Check the DAX

  • Use variables so an expression is calculated once rather than repeatedly.
  • Avoid iterating over very large tables when a simple aggregation will do.
  • Prefer measures over calculated columns for values that change with filters.
  • Look at measures that call many other measures, which can multiply the work.

3. Check the report page

  • Reduce the number of visuals on a page; each one sends its own queries.
  • Be careful with large tables and matrices that show many rows and columns.
  • Limit complex slicers and cross-filtering interactions where they are not needed.

4. Check refresh and the source

  • Consider incremental refresh for large tables.
  • Check that transformations fold back to the source where possible.
  • Consider aggregate tables when users mostly look at summary data.

When to ask for help

If you have worked through the list and the report is still slow, the issue is often a design decision deep in the model. A focused review can identify it quickly, and the fix is usually in the model or measures rather than in the visuals you see.

How we can help

← All insights

Let's build what's next.

Not sure where to start? Ask for a free dashboard review. We'll get back to you as soon as we can.

Prefer to talk it through? WhatsApp us Contact us by email

Our working hours overlap with the US, Europe and Asia-Pacific.

Start a project