Forum Discussion
Visual exceeded available resources error in Power BI
Hi, Analitika
Try filtering the visual to reduce the amount of data in the result.
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Your visual has attempted to query too much data for us to complete the result with the available resources. Try filtering the visual to reduce the amount of data in the result.
refer:
This visual has exceeded the available resources.
And you can follow the tips to optimize your report：
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 to use less memory and return faster or change what the visual displays.
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. ）
refer:
The “Visual Has Exceeded The Available Resources” Error In Power BI
Visual has exceeded the available resources - Table Visual
Data Import Best Practices in Power BI
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Analitika
This typically means that either the DAX measure is not well written and is using too much memory/CPU to complete the computation.
I would suggest making sure you are using a star schema in your dataset.
And then that your DAX measure is written as efficiently as possible?
Hi
In my report I have 879113 distinct member count. In data model each member may have multiple data. For one member count also drill through not working showing this same error. Saying exceeded memory consumption that a limit. It's Import.node report still why saying memory consumption please reply
Hi santosh_hmt
This is due to the fact that you have a lot of distinct members. And when doing a distinct count, it is very memory intensive. And that is why it is causing you to get that error. You would either need to remove. the amount of distinct members you have will get a larger capacity in order to get more memory.