Forum Discussion
Unable to refresh automatically : The evaluation reached the allowed cache entry size limit.
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 c...
MAwwad
Solution Sage
Solution SageYou 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:
- In the Power BI service, go to the "Settings" menu and select "Admin portal".
- In the Admin portal, go to the "Data gateway" section.
- Under "Data sources", click the name of the data source that you are having issues with.
- In the "Edit data source" page, click the "Advanced" tab.
- Under "Cache size", enter a larger value for the "Allowed cache entry size (MB)" setting.
- 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.
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