Forum Discussion
Power Bi Service Cache Error on Data Refresh
Resident RockstarHi Anonymous ,
More details will help us understand your scenario better. Please let me know the information below.
What data source do you use and how do you connect it?
When do you get this error? Manually refresh or schedule refresh?
Do you have the refresh error for all datasets or the specific one?
Please check if your gateway is online.
In addition, it seems that your error message is not complete, please share the detail error message for us so that we could help further on it.
Best Regards,
Cherry
Hi all,
I have the same error in Power BI Pro since yesterday (10/03/2019) in daily scheduled refresh:
Failure details:
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. Table: xxx.
I'm currently connecting to web data and this error are only for the Power BI Pro but when I refresh manually with Power Bi Desktop I have no problems. Also when I have forced by manually refresh in Power Bi Pro the smae error has appear.
Kind Regards,
I'm also having this same issue.
The message I recieve is identical: "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. Table: x".
This occurs for automatic refreshes on Power BI service. When I manually refresh on Power BI desktop, the refresh goes through, but when I publish to Power BI service, it won't update. I keep getting that same message.
The data source is an odata feed, but the other odata feeds in the dashboard work fine. The only particular thing I notice about this table is that it's large (>1,000,000 Rows).
I'm thinking I might be able to trim the data, to reduce the size of the query.