Unable to refresh automatically : The evaluation reached the allowed cache entry size limit.

[diazjp]

sudenly my dashboard is not refreshed automatically as usual and it throws error like this

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 IDbCommand interface.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: a9e9a792-d673-4af3-9f4d-0a8aa67dcfa8
Request ID: f20785a0-0f54-49a4-b809-773d6e336274
Time: 2022-12-22 04:19:01Z

but if the dashboard refreshed from Desktop, it's working just fine, but if i refreshed from workspace it wont work, i already add more data cache size and republish to the workspace, but still error, i have explore all the thread related this issue but there was no answer or solution, if anyone know how to solve this, please help, thank you.

[MAwwad]

You are experiencing an error when trying to refresh your Power BI dashboard from the workspace. There could be a few different reasons why this error is occurring, but one possibility is that the data cache size limit has been reached.

To resolve this issue, you can try increasing the allowed cache size for your data sources. To do this, follow these steps:

1. In the Power BI service, go to the "Settings" menu and select "Admin portal".
2. In the Admin portal, go to the "Data gateway" section.
3. Under "Data sources", click the name of the data source that you are having issues with.
4. In the "Edit data source" page, click the "Advanced" tab.
5. Under "Cache size", enter a larger value for the "Allowed cache entry size (MB)" setting.
6. Click "Save" to apply the changes.

After increasing the allowed cache size, you should be able to refresh your dashboard from the workspace without encountering this error.

[diazjp]

Thank you for your valuable answer !, i will try it, but first i need to ask the it admin for this task since i didnt have the access for PBI Service setting