Memory Allocation Failure

Hi, Raj_j 

Could you check if the file size exceeds 1GB?

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

Some basic steps that usually work are:

• Increase available memory (if you are for example working from a VM)
• Remove all unnecessary columns in the power query editor
• Allocate more memory in the data load option in power bi (options > data load)

Calculated (dax) columns are not compressed as well as computed (power query) columns.  You could try and add your columns in power query instead.

Here are more references that may be helpful:

Memory error: Memory Allocation failure

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

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

FIX: Power BI Memory error allocation failure

Best Regards,
Community Support Team _ Zeon Zheng

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