Lagos, Nigeria

How to fix Memory error Allocation failure in Power BI?

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 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 post was written by Tashreef Shareef and was first posted to WindowsReport

Tags: , ,

%d bloggers like this: