Forum Discussion
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?
4 Replies
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]
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)?
I am just connecting to the dataflow. It loads well. Then I try activating the incremental refresh and I get the error
I am getting this on Power BI Service.
Steps:
Create Data Mart
Get Data (Excel from OneDrive. ~488MB)
Transform Data. (Change a few field types). Then Save and I get this error:Loading Data
Error Message PipelineException: The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.
HttpStatusCode 400
Activity ID 5b6c7c6b-44e3-5d55-69e8-f92a45b54afb
Request ID 271bd3b6-7d74-4969-b702-fe20d31d1856
Status code 500
Error Code CdsaMashupUserException
