Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.