Visual is not shown Lack of rerources

[Anonymous]

Hello,

When I try to see a Matrix in services, it cannot be displayed due to a lack of resources. The error message is "the visual exceeded the available resources". In Power BI desktop is also not displayed.

It consists of about 10 calculated metrics and has to evaluate many rows during 3 years of data. To reduce the load I have tried filtering for a specific day with a slicer but it still doesn't show.

This is the performance of the metrix not showed:

Is there any way to optimize the load or make the visual displayed without having to remove or edit the DAX metrics from the report?

Thank you

[v-xicai · Accepted solution]

Hi @Anonymous ,

The error occurs when a visual attempts to query too much data for the server to complete the result with the available resources.  You may need to filter the visual to reduce the amount of data in the result currently. That way, the error might be resolved.

You can also optimize your data model following the guide in the blogs below, and re-publish your PBIX file to Power BI Service.

Power BI Performance Tips and Techniques

Data Import Best Practices in Power BI

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.