Power Bi Service Cache Error

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.