Power Bi Service Cache Error on Data Refresh

[Anonymous]

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

[prosolBI]

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!

[SHHargrove]

Mine has been fixed.  Thank you.

[robemie_0119]

Hi! May I know how this issue has been fix? I am having the same problem.

[Anonymous]

I'm still having this issue and cannot find a solution for it anywhere. Is there a way to fix this? our customers are concerned. 

[Juha]

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.

[Juha]

Still not fixed. Now fix expected by end of today. I am not convinced.

[LavinaVRovine]

Not fixed in my case.

[triciabi]

Mine was fixed. 

[LavinaVRovine]

my seems to be working as well

[Anonymous]

Mine has fixed as well

[smintos]

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?

[Juha]

Not fixed. It's still in https://powerbi.microsoft.com/en-us/support/ now with fix expected by end-of-day on March 18th.

[Juha]

The issue still persists. Hoping this will be resolved soon, as it prevents the refresh of reports.

[SHHargrove]

we are having the same problem, but only with one of our datasets

[LavinaVRovine]

@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 podrobnosti

Chyba 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

[v-piga-msft]

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

[triciabi]

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

---

[Anonymous]

Looks like they are having some problem that are in the support portal:

https://powerbi.microsoft.com/en-us/support/

[triciabi]

---

@Anonymous wrote:

Looks like they are having some problem that are in the support portal:

https://powerbi.microsoft.com/en-us/support/

---

Thanks for the update. 

Their response to this issue is below: 

Some customers may experience the following error when attempting to perform a Refresh that utilizes M queries: “We're sorry, an error occurred during evaluation. The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size”. Engineers are working on a fix and will provide an ETA soon.

[Anonymous]

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,