Forum Discussion
Visual has exceeded available resources
Hi all,
I have a report that has run fine for the better part of a year without any issues. The heavy lifting is done through a saved sql query. I'm then combining that with a few tables from our ERP system.
Last week a user asked for antother field to be shown on the report. It was a field that already existed within a queried table. I added the field and the report ran fine for 3 days.
Then the problem started where the report would spin for a few minutes and give the "exceed resources" message. When I try to load the report in the desktop application, our server's CPU redlines at 100% usage. I've tried to remove this field to revert the report back to it's last working state but it doesn't help. I've tried to re-create the visual of the report from scratch, but that still runs me into the same problem.
I've had our third party IT vendor look at any server issues and they don't think there is anything wrong there.
Anyone seen this or have any suggestions?
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
4 Replies
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.⚡
Mattmcdowell_ , refer to if these old solutions can help
https://community.powerbi.com/t5/Service/Visual-has-exceeded-available-resources/m-p/844802
https://community.powerbi.com/t5/Desktop/Resources-Exceeded/m-p/911634
Also check what other applications are running, how much CPU and RAM they are taking
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 _ EasonExcellent support provided by Laasya Engineer -Microsoft Business Intelligence,
I’m pleased to inform you that after switching to the Premium license, after activation issue has been resolved, and report visuals are now functioning for all pro users.
Thank you once again for your time and assistance in resolving this issue.
