When i tried to filter the visuals in the Dashboard getting below error.

Question

Answer 1

The error message indicates that the visual query in the dashboard has exceeded the available resources (memory). In Power BI this typically occurs when a visual tries to query or process too much data at once.

To mitigate this, reduce the amount of data the visual needs to load and aggregate:

1. Add or tighten filters on the visual
   • Limit the date range.
   • Reduce the number of categories or dimension values shown.
   • Apply additional filters in the Filters pane so the visual only returns the data necessary for the analysis.
2. Simplify the visual
   • Remove fields that are not essential from the visual’s Values, Axis, Legend, or Rows/Columns.
   • Avoid showing detailed row-level data when an aggregated view (for example, sums by month or by category) is sufficient.
3. Split the visual into multiple visuals
   • Instead of one very large visual, create several smaller visuals, each showing a subset of the data (for example, by region, time period, or business unit).
4. Work with the model owner (if applicable)
   • If the dashboard is based on a large semantic model, coordinate with the model owner to optimize the model or add aggregations so visuals can be answered with less memory.

These steps align with the documented guidance for the error “This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.”

---

References:

• Troubleshoot Power BI tile refresh errors