Forum Discussion
Loading Issue - Stuck on sample file
I am loading 4 queries, 2 are querying local folders, 1 is a copied query with some different filters and 1 is an 'append as new' query. When loading to the model, the loading of the data gets stuck ...
Hi Davis-CMC ,
Please have a try.
- Review and optimize your Power Query steps to ensure they are as efficient as possible. Remove any unnecessary transformations and consider simplifying complex ones.
- Try splitting the data load process. Instead of appending all at once, append in smaller chunks to see if that helps avoid the memory issue.
- Instead of refreshing all queries at once, try refreshing them one by one to isolate the problem and to prevent memory overflow.
- Ensure that you are using the latest version of Power BI Desktop, as updates often include performance improvements and bug fixes.
Solved: insufficient memory to complete this operation - Microsoft Fabric Community
Solved: There is not enough memory to complete this operat... - Microsoft Fabric Community
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.