Solved: Memory error: Memory allocation failure.

Anonymous · ‎09-13-2022

Have sufficient storage in system still getting this error.

nvprasad · ‎09-13-2022

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos.
Follow me on LinkedIn.

View solution in original post

nvprasad · ‎09-13-2022

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos.
Follow me on LinkedIn.

Anonymous · ‎09-13-2022

While loading data, i am getting this error

ReneMoawad · ‎09-13-2022

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 · ‎09-13-2022

fr_evnt_rec_src_fv has more records

ReneMoawad · ‎09-13-2022

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)