Forum Discussion
visual exceeds available resources
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
6 Replies
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.
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-Forum/ba-p/963216
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.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 👍
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?
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 👍
