Forum Discussion
Visual has exceeded available resources
- 6 years ago
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
Excellent 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.