Forum Discussion
Power Bi Service Cache Error on Data Refresh
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.