Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 21
prosolBI
Frequent Visitor

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
Advocate II
Advocate II

Mine has been fixed.  Thank you.

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

Anonymous
Not applicable

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
Frequent Visitor

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
Frequent Visitor

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

Not fixed in my case.

Mine was fixed. 

my seems to be working as well

Anonymous
Not applicable

Mine has fixed as well

smintos
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

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

SHHargrove
Advocate II
Advocate II

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

LavinaVRovine
Frequent Visitor

@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
Resident Rockstar
Resident Rockstar

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Not applicable

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

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

 


@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
Not applicable

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,

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.