Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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."
Solved! Go to Solution.
hi @Ajoaquin36 ,
You can try these:
To fix the "Not enough memory" error in Power Query:
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.
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.
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.
hi @Ajoaquin36 ,
You can try these:
To fix the "Not enough memory" error in Power Query:
Hi,
I have tried it on another computer with greater capacity and everything works fine. Thank you very much for the answers