I have a simple aging report for about 700 clients and a measrure that calculates 9 periods for "dynamic aging" (based on selected date). The fact table have about 250k rows. The saved PBIX file about 35 MB and a single matrix visual on a single page along with a date slicer.
On the desktop all is fine, until I publish the report and cannot display the matrix because of the "Resource exceeded" error.
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Please try again later or contact support. If you contact support, please provide these details.
More detailsResource 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 1048583KB, Limit 1048576KB.
TimeThu Jun 04 2020 22:31:18 GMT+0300 (Eastern European Summer Time)
The detailed error is interesting: "Requested 1048583KB, Limit 1048576KB" so for a 7KB difference I sould pay for dedicated capacity?...
I have more complex reports that runs fine but a simpler one did not?... what is the catch?... What am I missing?
I have tried to filter "zero values" but the eror is the same. If I put a client name slicer I could select about 25 of them until the matrix will crush.
Is there a way to solve the 7KB difference and make the report work online?