Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

dacoil

Memory overflow when updating an Aggregated table on query create

Submitted by on ‎07-31-2017 03:02 PM

We are running out of memory when using the aggregation function on the data query editor.  It has been working for the last 6 months with no issue. 

 

From the refresh

Processing error:

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

Cluster URI:

DF-MSIT-SCUS-redirect.analysis.windows.net

Activity ID:

af3be4d7-3ecf-4362-92fa-e388b67e7f56

Request ID:

1ae579e5-2dea-6a64-309d-9e14aa55882c

Time:

2017-07-31 18:32:30Z

  
Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎08-01-2017 01:03 AM

Hi @dacoil,

 

The same issue reported before: CRI 41648058, CRI 41469240. Please check below infomration:

 

"User is hitting the 10 GB memory limit during processing. That's the reason his processing request is failing. He can try processing his model from desktop and monitor memory utilization. If it exceeds 10 GB then the processing will not be successful in the service. There is no such limit on desktop. User can either update his model to get less data during processing request or use direct query. "

 

Best Regards,
Qiuyun Yu

Idea Statuses