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

gjadal's avatar
gjadal
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Can you elaborate on what this means?

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.

 

  • Jim_'s avatar
    Jim_
    Icon for Advocate I rankAdvocate I
    8 years ago

    I believe that this means that there is more of a memory drag when you create columns during the import vs. when you have all of your tables loaded.