visual exceeds available resources

[finley0726]

My visual is fine at first but when I start clicking on the + to expand the data then the visual exceeds available resources. The last column is a huge measure which is causing the issue. The measure is based on 10 other measures (which have other measures in them). The last column is the summation of all 10 measures to produce an overall score out of all measures. Please please please help me with alternative solutions if you know of any 🙂 My VP does not want to use slicers to filter the data. He wants to see all the data together in a roll up by region/state if that makes sense. If you know of a solution to make this work or have any ideas of how to simplify the large calculation in the last column please let me know

[foodd]

Chris Webb in one of his latest blog posts addressed this by adding context to the condition 'visual exceeds available resources'.  I never argue with Chris Webb.

The official workaround from Microsoft is to try filtering to decrease the amount of data displayed.

The visual has tried to query too much data for Power BI to complete the result with available resources. Try filtering the visual to reduce the amount of data in the result.

@Idrissshatila's recommendation to examine and rework your  model in terms of Star Schema 

holds much value.

[Idrissshatila]

Hello @finley0726 ,

Try reducing the load on Power Bi, Try doing the model as star schema Modeling.

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[finley0726]

So if I filter the months to just May June and July, the visual works. It only crashes when I try to add August (current month's data). Do you know why this is?

[foodd]

As you have not shared your model, or some minimum representative data, a recommendation would be to sit down with the measures and data sources to determine what has become costly, and why.   Tools to help would be DAX Studio, Tablular Editor, and Measure Killer.   It sounds as if you need to break it down and profile all aspects.    I would be open with your leadership as you need to explain this in plain language if needed.    Blanket answers like "I hate slicers" can be worked around. 

Brainstorming:   If you query August (or same month) values alone, does the visual hang up?   

[Idrissshatila]

Hello @finley0726 ,

Yes thats becaus of the huge load, so when you filtered you minimized the data that should be displayed.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.