Forum Discussion
Matrix Visual Error on Power BI Service
- 1 year ago
I ran a test and it worked. I literally removed the DAX measures from the matrix visual one by one, publishing the report after each change to see if the issue persisted or if something specific was causing the error.
Surprisingly, after removing and re-adding the same DAX measures — without changing their logic — everything went back to normal. The matrix visual is now displaying data correctly using the same visuals and same DAX formulas.
It seems the issue was resolved simply by re-inserting the measures.
FBergamaschi thank you!!
Hi GabrielFalconi ,
Given the impact on large datasets across two client reports, please consider the following troubleshooting steps:
Limit matrix size:
Reduce the number of rows or columns, or filter to the top N categories. Try to keep columns under 100 and avoid complex cross-joins.
Troubleshoot visualizations in Power BI
Optimize the model:
Simplify DAX expressions (use VAR where possible), minimize data in Power Query, and monitor performance with the Performance Analyzer to ensure visuals stay within 225 seconds and 1 GB of memory.
Use Performance Analyzer in Power BI Desktop
Test alternatives:
Try using a table visual instead of a matrix to determine if the issue is specific to the matrix visual.
Simulate service limits in Desktop:
In Power BI Desktop, go to File - Options - Data Load - Query Limits and set the timeout to 225 seconds and memory to 1 GB.
Try older Power BI Desktop versions:
Some matrix-related issues have been reported after the June/July 2025 updates. Test with the February 2025 version if possible.
Download older versions of Power BI Desktop
Use Paginated Reports:
Paginated Reports may be better suited for rendering large tabular datasets.
Paginated Reports in Power BI with Report Builder
Contact Support:
If the issue continues, please submit a ticket at https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Best regards,
Sreeteja.