// troubleshooting guide · microsoft power bi

Power BI Visual Has Exceeded the Available Resources

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

RUNBOOK · power-bi/visual-exceeded-resources4 FIXES

// quick answer

This error means one visual's query used more memory or time than the Power BI service allows. Filter the visual to return less data, simplify the DAX measure and remove unneeded columns; on Premium/Fabric an admin can raise the query memory limit.

Most likely fix: Filter the visual

How to fix it

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

  1. FIX 1Filter the visual

    1. 01Add a visual-level or page filter (date range, top N)
    2. 02Remove high-cardinality columns such as IDs from tables
    3. 03Use drillthrough for detail rows
    Did this fix it?
  2. FIX 2Optimize the DAX

    1. 01Find the visual in Performance Analyzer and copy its query
    2. 02Rewrite iterators over large tables with simpler aggregations
    3. 03Pre-calculate expensive columns in the source or Power Query
    Did this fix it?
  3. FIX 3Slim the model

    1. 01Remove unused columns and tables
    2. 02For DirectQuery or composite models, use aggregations
    Did this fix it?
  4. FIX 4Raise the limit on capacity

    1. 01On Premium or Fabric capacity, ask the capacity admin to raise the query memory limit in capacity settings
    2. 02This option does not exist on shared (Pro) capacity
    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

A visual shows 'Visual has exceeded the available resources' or 'Resource Governing: This query uses more memory than the configured limit', often only in the service while Desktop works.

Why it happens

  • C-01Table or matrix visual returning a huge number of rows
  • C-02Memory-hungry DAX measures
  • C-03Stricter per-query limits in the service than on your PC
  • C-04High-cardinality columns in the visual

// this guide also covers

  • visual has exceeded the available resources
  • power bi resource governing query memory limit
  • power bi visual exceeded resources

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

Other Microsoft Power BI errors

All 14 Microsoft Power BI errors and fixes →