Power Bi Service Cache Error

[Anonymous]

Hi Everyone

I am doing a schedule refresh and I am getting the following error, anyone who can kindly advise?

Data source error: We're sorry, an error occurred during evaluation.;The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: DimDataAgentDetails.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 6f4ef2f1-7c3d-4e4c-bfde-5af81f3641fa
Request ID: 68b7f84b-1dc9-4e2f-b3d3-8f478ae38dd8
Time: 2023-02-12 14:31:50Z

[jaweher899]

To resolve this issue, you can try the following steps:

1. Increase the cache size limit: You can increase the cache size limit to allow for larger query evaluations. This can be done in the settings for your data source.

2. Optimize the query: If increasing the cache size limit is not feasible, you can try optimizing the query by reducing the number of columns, filtering the data, or using a different aggregate function.