Forum Discussion

ERing's avatar
ERing
Icon for Post Partisan rankPost Partisan
1 year ago

Help resolving "Error fetching data for this visual"

I have a simple dashboard with a few donut charts and a Matrix. The matrix continually fails to load and shows the error shown below "Error fetching data for this visual. The resultset of a query to ...
Need Help
Shivu-2000's avatar
Shivu-2000
Icon for Responsive Resident rankResponsive Resident
1 year ago

Hi ERing 

Follow the given steps to find the problem and solve it as:

  1. Use Performance Analyzer in Power BI Desktop to capture the DAX query for the matrix. Run it in DAX Studio to identify issues with query size or performance.

  2. Optimize Data Model:

    • Filter Data: Apply filters in Power Query or at the source to reduce the dataset size.
    • Remove Unnecessary Columns: Keep only columns needed for the report.
    • Use Aggregation Tables: Summarize data and use these in visuals.

  3. Adjust the Matrix Visual:

    • Simplify fields in the rows, columns, or values sections to avoid excessive granularity.
    • Ensure filters are applied to reduce the data being visualized.

  4. Switch to Import Mode:

    • Break large tables into smaller chunks if Power BI fails to process them in Import Mode.
    • Optimize Direct Query tables with proper indexing or pre-aggregated views.

  5. Power BI Settings:

    • Increase memory for queries: File > Options > Current File > Data Load > Maximum Memory Used per Query.

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