Forum Discussion
Power Bi Service Cache Error on Data Refresh
we're sorry, an error occured during evaluation, the evaluation reached the allowed cache size limit, try increasing the allowed cache size, the exception raised by the IDbCommand interface
21 Replies
v-piga-msft Getting same error since around Friday/Saturday 08.03.2019/09.03.2019.
Using web connector to download CSV file. The error happens only with "large" files, ie > 1M rows
The error happens with both on-demand and scheduled refresh, but no trouble is encountered in PBI offline.
Full error:
Poslední neúspěšná aktualizace: Tue Mar 12 2019 10:40:52 GMT+0100 (Středoevropský standardní čas)
Při zpracování dat v datové sadě došlo k chybě.Skrýt podrobnostiChyba zdroje dat: 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: Unique Shops. URI clusteru: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net ID aktivity: 05c1bf0c-8e33-4210-8bf4-370e654af625 ID žádosti: 80c4def9-f80e-4818-9f36-57e04a19940e Čas: 2019-03-12 09:40:52Z Hi 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.
Had the same problem since Monday. Has anyone found a solution yet?
My data source is OneDrive and this was a scheduled refresh on all data set. I used to have larger data tables but such issue did not occur. I tried manual refresh but got the same error message. For other reports with much smaller datasets the refresh didn't seem to have any problems.
Thanks.
Please try again later or contact support. If you contact support, please provide these 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: orders_mass_action. 叢集 URIWABI-EAST-ASIA-A-PRIMARY-redirect.analysis.windows.net 活動 IDe835e566-f958-4f4e-8617-da594a17d87d 要求 ID98840b17-46ab-422c-a3e5-72a55c80b742 時間2019-03-11 04:23:43Z
v-piga-msft wrote:Hi 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
Looks like they are having some problem that are in the support portal:
https://powerbi.microsoft.com/en-us/support/
we are having the same problem, but only with one of our datasets
The issue still persists. Hoping this will be resolved soon, as it prevents the refresh of reports.
We also receive this errors since days. For our Premium / Embedded PBI Version & also for alot of our Pro Accounts within PBI Service. The issue is not listed anymore at: https://powerbi.microsoft.com/en-us/support/
Is the issue already solved for some of you?
Not fixed. It's still in https://powerbi.microsoft.com/en-us/support/ now with fix expected by end-of-day on March 18th.
Still not fixed. Now fix expected by end of today. I am not convinced.
Not fixed in my case.
Mine was fixed.
Now when this issue is appearantly fixed for some, there is another problem preventing report refresh:
Customers in the North Europe region may experience issues with Refreshing and Publishing reports. Engineers are investigating the issue.
It's been more than a week now that I have not been able to refresh my reports. Quite clearly, I am not impressed.
Mine has been fixed. Thank you.
Hi! May I know how this issue has been fix? I am having the same problem.
Hi!
We are having the same issue: "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."
Any help?
Thank you!
