Forum Discussion
Visual has exceeded available resources
Hi , Mattmcdowell_
When you run a DAX query in Power BI it will always use a certain amount of memory,inefficient DAX calculations can cause a query to try to grab a lot of memory.
So there is a resource governor that will kill queries that are too resource hungry. In the case of the visual above the query behind it tried to use more than 1GB of memory and was killed by the resource governor.
Some tips:
1.Do not expose in a view a column that is not necessary in the Power BI data model.
2.Optimize the DAX calculation used in this visual effect
3.Remove unnecessary precision or split granularity values to reduce cardinality
（Significantly reduce highly unique datetime values by splitting the date and time into separate columns. ）
4.Pay attention to your memory usage
For more details,please refer to these related post:
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
Best Regards,
Community Support Team _ Eason
Mattmcdowell_ performance is always a tricky thing. Start with a performance analyzer and see what visual is taking long, look at Dax query in performance analyzer, and thru DAX studio check what measure is taking long (if there are any) and go from there. It is not going to be straight forward answered but will require a lot of debugging to figure out. If there are multiple measures and tables, relationships of tables and measure expression can lead to bad performance. I know you mentioned it was working fine but adding a new column lead to poor performance, there could be other reasons, not necessarily it happened because you added a new column.
How big is the data model?
How tables are related?
What are the measures?
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡