Forum Discussion
visual exceeds available resources
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 👍
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?
