Forum Discussion

Jim_'s avatar
Jim_
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Memory error: Memory Allocation failure.

Hi All, Let me preface this by pointing out that I am still in the learning phase of Power BI and associated skill sets, so please excuse the ignorance. I am having an issue with a refresh failing ...
Need Help
  • Jim_'s avatar
    Jim_
    9 years ago

    I went into the query editor and removed as many columns as possible and the refresh started working again.  Also, I received this nugget of wisdom from Support:

     

    From a memory consumption perspective it is better to add columns in the report developer using the add new measure/column function for optimized performance.

     

    I hope that this can help someone else.

     

    Thanks!!!

    Jim

Jim_'s avatar
Jim_
Icon for Advocate I rankAdvocate I
9 years ago

I went into the query editor and removed as many columns as possible and the refresh started working again.  Also, I received this nugget of wisdom from Support:

 

From a memory consumption perspective it is better to add columns in the report developer using the add new measure/column function for optimized performance.

 

I hope that this can help someone else.

 

Thanks!!!

Jim

HavenerTed's avatar
HavenerTed
Icon for Advocate I rankAdvocate I
2 years ago

I have a 110 table model including 2 tables that exceed 2 million rows. I am experiencing this error. I have tried so many different solutions and I want to avoid removing columns as much as possible since this model was created by our DBA team. I was wondering if anybody knows if an incremental refresh would help this. 

 

Thanks!