Forum Discussion
Solved
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 ...
hi Ajoaquin36 ,
You can try these:To fix the "Not enough memory" error in Power Query:
- Switch to 64-bit Excel: Handles larger memory allocations.
- Optimize Queries: Remove unnecessary columns/rows, disable previews, and use Table.Buffer.
- Split Complex Queries: Break into smaller parts.
- Optimize Data Model: Avoid adding unused data to the model and reduce dimensions.
- Increase Virtual Memory: Adjust system paging file size.
- Close Other Applications: Free up system resources.
- Avoid Data Model: Load data directly to PivotTable.
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.