Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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's avatar
triciabi
Frequent Visitor
7 years ago

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

 

    • triciabi's avatar
      triciabi
      Frequent Visitor
      7 years ago
      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.