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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
webportal
Impactful Individual
Impactful Individual

Dataflow PipelineException: The evaluation reached the allowed cache entry size limit. Try increasin

My dataflow is retrieving data from Azure blobs.

 

It is returning the error upon refresh:

 

PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size. 

 

When copying and pasting the code into Power BI Desktop (Power Query), it all goes fine.

 

How can I fix this?

 

Thank You!

6 REPLIES 6
duffby2
Frequent Visitor

Has there been any resolution to this issue? I have the same issue on a dataflow failing with this error message (Error: PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size..).  
Is the cache entry size limit only available to admins? Or is there another solution. 

 

Note that I have seen some references to changing Power BI desktop settings but this issue has nothing to with Power BI Desktop nor any semantic model for that matter.  The failure is occuring during the dataflow refresh. 

mike_haward
New Member

I am also having this issue - like the original post in the dataflow NOT in any Power BI Desktop element.  I am on a Fabric capacity.  Where in the Power BI service can I adjust the cache limits?

 

Error: PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size

webportal
Impactful Individual
Impactful Individual

@v-yangliu-msft 

 

Thank you. The dataset is completely validated in Power BI Desktop, and the cache size has also been adjusted in Power BI Desktop.

 

The error refers to Power BI Service Dataflow (ie, before the data is read by Desktop).

Hi, I'm having the same issue when trying to refresh a Power BI Service Dataflow. Were you able to find a fix for this error? Thanks

v-yangliu-msft
Community Support
Community Support

Hi  @webportal  ,

 

Try to increase the Maximum allowed (MB).

Cache Size for Power BI Desktop

It's good practice that before you schedule the report, you validate the complete dataset. One additional help for this, especially in the cases of larger datasets retrieved from the API, is to increase the cache limits. This increase can improve PowerBI's performance and stability. To configure this:

  1. Click Settings->Options->Global->Data Load to expose the "Data Cache Management Options".
  2. Try increasing the Maximum allowed (MB):to 16000 (or about double what the current setting is).

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

I'm getting this and went up to 100000 MB as a test. It works on older versions of power bi desktop, but i can't get it to work on the Dec 2022 or Feb 2023 versions. I get this same message on all my larger tables. 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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