Forum Discussion
Memory error: Memory allocation failure.
Have sufficient storage in system still getting this error.
Hi,
If you know the table which is causing the error then try to remove unneccessary columns & push any transfomraiotns to the database instead of performing transformations in PowerQuery Editor.
If you done above steps, still if you getting error, then split query into mutliple queries then refresh the report.
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution! Regards,
N V Durga Prasad
5 Replies
Hi,
If you know the table which is causing the error then try to remove unneccessary columns & push any transfomraiotns to the database instead of performing transformations in PowerQuery Editor.
If you done above steps, still if you getting error, then split query into mutliple queries then refresh the report.
Appreciate a Kudos!
If this helps and resolves the issue, please mark it as a Solution! Regards,
N V Durga PrasadHi Anonymous ,
You need to go to the Model page
Select couple of tables and refresh them, than do the same for the remaining tables (Make sure you don't select the Calculated Tables, they will be refreshed automatically after you refresh the tables)
Try to load 1 table at a time so you can see which table is the most heavy one, so you can try to fix the query
