Memory Allocation Failure

[Raj_j]

Hi,

I'm geting memmory Allocation Failure om Power Bi Desktop.

I have removed as many columns as i could but fail to change a date format or even add a column to my report/dashboard.

Any help would be appreciated.

Thanks

[ramdasanudas]

get more space in C: drive
or
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again

[v-angzheng-msft]

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.

[Raj_j]

Hi and Thnaks for your response.

I'm not sure on the size of the data as it's coming straight from the database.

I have adjusted my pagefile size to 16gb and Data Load to 2K and i still get the error.

I am running Power Bi 32 bit version as i couldn;t get my ingres odbc connection working for the 64 bit

Thanks

[Greg_Deckler]

@Raj_j You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Raj_j]

Thanks for you response. 

I checked out your first solution before posting but thank you.

For the second solution, it won't let me create a ticket as we are licensed for Microsoft products by a reseller so our Admins are logging it on my behalf.

Thank you