Memory Allocation failure . Try simplifying or reducing the number of Queries

[Anonymous]

Hi,

I've had a file in the service for quite a while now (over a year) and just recently I started getting the following error.  I've made any big recent changes especially to the number of queries.

Thanks,

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 937a2912-c631-47ab-ab50-23ddb015c2c7
Request ID: cec4336a-bbe7-4d54-b7a8-39cf1cb30ddc
Time: 2020-05-20 14:03:40Z

[v-gizhi-msft]

Hi,

Hope these can help:

https://community.powerbi.com/t5/Service/Memory-error-Memory-Allocation-failure/td-p/229420 

https://windowsreport.com/memory-error-allocation-failure/ 

Best Regards,

Giotto

[Anonymous]

My problem is with the Power BI service, not the desktop version, so I don't think the second one applies. 

I've reviewed my queries, and I don't really have anything that complex.  Not to mention they've been working for a while.  The only new thing, is I do use summarizecolumns to create a inventory snapshot table.

I guess I could try removing that...  But I kind of need it.

[GilbertQ]

Hi there

It could well be that when you are creating this table (if the underlying data is large) it could cause it to consume a lot of memory.

This is because when you create a calculated table inside the Power BI dataset this is uncompressed and can consume a lot of memory.

The reason it could work on your desktop is because you are only limited by the amount of memory on your desktop which could be 8 or 16 or 32GB of RAM (Memory), whilst in the Power BI Service it is limited.

If you remove the table and it refreshes try and re-create the table in Power Query, this will allow the table to be compressed before it goes into the Power BI dataset.

[Anonymous]

Ok, I have confirmed that it is a new created table causing the problem.  But I confess I'm not that good with Power Query.  The DAX I am using to create the table is

Inv Summary Col = SUMMARIZECOLUMNS('Item Value New'[Item Ledger Entry Quantity], 'Item Value New'[Posting Date],
"Bal Qty", CALCULATE(SUM('Item Value New'[Item Ledger Entry Quantity]), FILTER(ALL('Item Value New'[Posting Date]), 'Item Value New'[Posting Date]<=MAX('Item Value New'[Posting Date] ) ) ),
"Bal Cost", CALCULATE(SUM('Item Value New'[Cost Amount (Actual)]) , FILTER(ALL('Item Value New'[Posting Date]) , 'Item Value New'[Posting Date] <= MAX('Item Value New'[Posting Date] ) ) )
) 

Can I do that in power query?

[GilbertQ · Accepted solution]

Hi there

I am certain that the above could be created in Power Query

I would suggest starting to learn Power Query, it will help solve a lot of data challenges you might face.

And there is a lot of free and paid resources on the web for Power Query training and learning.

[Anonymous]

Ok, I will put learning power query after I'm done reading "The Definitive guide to Dax".

Thanks,

[GilbertQ]

Could you have a look at the file size?

It would appear that it might be over the 1GB file size?

Or when it is refreshing the data because of too many queries it is running out memory?