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.
rohit1991
Super User
Super Userhi 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,
I have tried it on another computer with greater capacity and everything works fine. Thank you very much for the answers