Memory error: Memory allocation failure.

[Anonymous]

Have sufficient storage in system still getting this error.

[nvprasad · Accepted solution]

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

[Anonymous]

While loading data, i am getting this error

[ReneMoawad]

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

[Anonymous]

fr_evnt_rec_src_fv has more records 

[ReneMoawad]

Hi @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)