Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ajoaquin36
New Member

There is not enough memory to complete this action

I've been having a problem for several days when working in Power Query from Excel, I detail: after combining 2 queries I close Power Query to create a "PivotTable report" (checking Add this data to the data model) I get the message "There is not enough memory to complete this action. Close other applications, use the 64-bit version of Excel, or consider adding memory to the device."

1 ACCEPTED SOLUTION
rohit1991
Super User
Super User

hi @Ajoaquin36 ,
You can try these:

To fix the "Not enough memory" error in Power Query:

  1. Switch to 64-bit Excel: Handles larger memory allocations.
  2. Optimize Queries: Remove unnecessary columns/rows, disable previews, and use Table.Buffer.
  3. Split Complex Queries: Break into smaller parts.
  4. Optimize Data Model: Avoid adding unused data to the model and reduce dimensions.
  5. Increase Virtual Memory: Adjust system paging file size.
  6. Close Other Applications: Free up system resources.
  7. Avoid Data Model: Load data directly to PivotTable.

View solution in original post

4 REPLIES 4
v-saisrao-msft
Community Support
Community Support

Hi @Ajoaquin36,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-saisrao-msft
Community Support
Community Support

Hi @Ajoaquin36 

 
Thanks for reaching for Microsoft Forum community, we appreciate your inquiry regarding the "Not enough memory" error in Power Query. Along with the helpful suggestions from @rohit1991 , we would like to offer additional methods and best practices to optimize memory usage and enhance performance in Power Query. 

  • Consider using Power BI Desktop instead of Excel. It handles larger data volumes and offers superior data modeling. 
  • For large datasets, consider using an incremental refresh strategy in Power BI or other compatible data sources. This loads only new or changed data, saving space. 

Please refer to the documentation below for further details:: 

How to troubleshoot available resources errors in Excel - Microsoft 365 Apps | Microsoft Learn

 

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

Thank you. 

 

rohit1991
Super User
Super User

hi @Ajoaquin36 ,
You can try these:

To fix the "Not enough memory" error in Power Query:

  1. Switch to 64-bit Excel: Handles larger memory allocations.
  2. Optimize Queries: Remove unnecessary columns/rows, disable previews, and use Table.Buffer.
  3. Split Complex Queries: Break into smaller parts.
  4. Optimize Data Model: Avoid adding unused data to the model and reduce dimensions.
  5. Increase Virtual Memory: Adjust system paging file size.
  6. Close Other Applications: Free up system resources.
  7. Avoid Data Model: Load data directly to PivotTable.

Hi, 

I have tried it on another computer with greater capacity and everything works fine. Thank you very much for the answers

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors