FIX: Power BI Memory error allocation failure

Tashreef Shareef
by Tashreef Shareef
Windows & Software Expert
Last update:
Affiliate Disclosure

  • Users have reported that they can't use PowerBI because of a Memory error allocation failure error.
  • This is usually caused by insufficient memory on the hardware's behalf to process the given tasks.
  • You can go ahead and increase the available memory, which also works on virtual machines.
  • Additionally, you can try removing unused columns to make page processing easier.
To fix various PC problems, we recommend DriverFix: This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Power BI is a fantastic tool from Microsoft, and while it may not be the stablest software tool of its kind, it’s admittedly still new and under active development.

The memory allocation failure error in Power BI usually occurs if the system does not have enough memory to process the task at hand.

You can try to close some apps, allocate more memory or make edits to the original table to fix this error as reported by the users in the Power BI Community.

Hi
I have created a pbix file in 64bit machine. File Size: 22 MB. Rows: 5.5 Million Approx.
Data is fetched from MYSQL Database.
While I try to open the same file in a 32-bit machine, an error message pops up
“Failed to save Modification to the server. Error returned: Memory Error : Allocation Faliure. If you are using 32 bit version of the product,consider upgrading to the 64 bit version or increasing the amount of memory available on the machine”.

Follow the troubleshooting tips in this article to fix Power BI allocation failure error.

Not enough memory error in Power BI

1. Increase the memory available on the Machine

power bi memory error allocation failure
  1. If you are using the service on a Virtual Machine, check if the allocated memory is enough for the operations.
  2. Since you are getting this error, try to allocate more memory to the machine.
  3. You can also try to better utilize the available memory by optimizing your data model.
    • You can check the Internet for guides on optimizing your data model.

This guide will make you a better Power BI user. Do check it out.


2. Enable Windows page file

  1. The error can also occur if your system has Windows Page File disabled.
  2. Login with the Administrator account to your system.
  3. Press Windows Key + R to open Run.
  4. Type control and click OK to open the Control Panel.
  5. Click on System and Security.
  6. Click on System.
  7. From the left pane of the System window, click on Advanced System Settings.
  8. By default, you should be in the Advanced tab.
    power bi memory error allocation failure
  9. From the Advanced tab, click on the Settings button under the Performance section.
  10. Open the Advanced tab in the Performance Options window.
    power bi memory error allocation failure
  11. Click the Change button under Virtual Memory section.
    power bi memory error allocation failure
  12. Make sure Automatically manage paging file size for all drives option is checked.
  13. Click OK to save the changes.
  14. Restart the computer and check if the memory allocation failure error.

3. Other solutions to try

power bi memory error allocation failure
  1. Try to remove any unnecessary column in Edit Queries before importing in the data model.
    • While Power BI supports 2bn rows and 16,000 columns, it can be limited by the machine performance.
  2. Try to allocate more memory in the Data Load tab. From Power BI dashboard, open Option > Data Load.
    • Now increase the maximum allowed memory.
  3. If you using 32-bit Excel app, I would recommend you to use 64-bit Excel which should overcome any memory limitation issues.
  4. Memory issues can also be caused by too many columns and bad cells, but thankfully enough these can be fixed.

This concludes our article covering the temporary memory allocation in PowerBI. Let us know if there is any other method you know of that we may have skipped, and we’ll update the article accordingly.

This article covers:Topics:

There are no comments yet. Please leave a comment

add a comment

Leave a Reply

Your email address will not be published. Required fields are marked *