cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBITestingG
Helper II
Helper II

Datamart increase cache

Hi all,

 

I am using a dataflow as source for my datamart, whenever I try to activate incremental refresh for the datamart (the dataflow has it), I get an error telling me to increase cache size

 

I am not able to find where this increase cache size option is, I assume is similar to the desktop option?

3 REPLIES 3
otravers
Super User
Super User

Are you connecting to any other data source in the datamart besides the dataflow? And are you using the data gateway (which is not needed between a datamart and a dataflow)?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

I am just connecting to the dataflow. It loads well. Then I try activating the incremental refresh and I get the error

PowerBITestingG
Helper II
Helper II

Here is the error code:

 

Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [InnerType]=ErrorException The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size. [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=66437]/MashupDataAccessException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(InternalMashupException)[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(ErrorException)[HResult=-2146233088] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=66437]

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors