Visual has exceeded the available resources - new error on a known working report
Detailed error message:
Resource Governing: The memory used by the query exceeded the configured limit. The query or calculations referenced by it might be too memory intensive. Please consider simplifying the query or calculations. If the dataset is hosted on a dedicated capacity/server, you may also reach out to your capacity/server administrator to see if the per-query memory limit can be increased. Additional information: Requested 1048577KB, Limit 1048576KB.
This is on a Matrix visual on a report that has been used for about 6 months without issues.
No changes have been made to the report.
When I add a slicer and filter the data, it renders correctly.
The matrix is fairly large, it contains 4 "Rows" and 6 "Values". However as stated above, this matrix has been working fine for months.
The expected behaviour is that even though the data set is large, the visual loads the first 1000 rows, and continues loading as you scroll down.
Has something recently changed on the Power BI service regarding resource limits?
This is on a Power BI Pro license.
EDIT: Just to add, I have tested this on Power BI Desktop, where it works as expected. This issue is only in Power BI Service.