Forum Discussion
Data Load Issue using Multiple tables append and Multiple left merge queries
Hi Nisha_Goyal,
Please try using a Power BI Dataflow in the service to perform your merges and appends this can help offload the heavy processing from Power BI Desktop and may resolve the memory allocation issue.
Memory error: Memory Allocation failure. Try simpl... - Microsoft Fabric Community
Solved: Memory error: Memory Allocation failure on Power b... - Microsoft Fabric Community
Thank you.
Memory allocation failure appears cause there is too much data.
You should try to import less (less columns, less rows).
You can try to run Performance Analyzer in PBI Desktop to see if you have any bottlenecks.
You can also try to split big merges/appends in multiple steps.
Another idea could be incremental refresh -> https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Are you using PBI Pro or Premium Per User or more?
If this helps feel free to mark it as a solution and give a kudos 👍