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

[Anonymous]

When receiving this message, is there any advice from anyone on how to target the issue query/queries?

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

I have a large no. queries in my data model, that all refresh locally but not in the service.

Thanks

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, I think that your workspace contains datasets that are too large, which leads to memory allocation failure. You should keep in mind that datasets stored in pbix files are highly compressed.

Therefore, I suggest you take measures against the dataset which causes this problem. You can try these measures:

1. Go to the power query editor in Power BI desktop, delete the useless columns. Then publish it to service to replace the original one.
2. Upgrade your workspace to Premium Capacity, which supports the bigger size of dataset refreshing.
3. Stagger the refresh time, try to refresh large datasets in free time.

For more information:

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

https://community.powerbi.com/t5/Service/Memory-Allocation-failure-Try-simplifying-or-reducing-the-number/td-p/1099171

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

Best Regards,

Community Support Team _Robert Qin

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