FIX: Power BI Memory error allocation failure

2 minute read
power bi memory error allocation failure

Home » Fix » FIX: Power BI Memory error allocation failure

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.

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 support 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.



Next up

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading

FIX: Ubisoft server unavailable

John Taylor avatar. By: John Taylor
2 minute read

The market is filled with game distribution platforms like Steam, Epic Games Store or GOG. As such, some gaming giants have decided to build their […]

Continue Reading