cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BWL
Helper II
Helper II

August update System.OutOfMemoryException

Dear all,

 

After the August update my reports give the error SystemOutOfMemoryException. 
But when I  refresh it seperatly everythings works fine.

 

 

Is this a bug that will be fixed with the next update, or is something in my model?

 

OutofException.JPG

 

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @BWL,

 

It seems like your report contains multiple query tables with correspondent records.

 

Can you please provide more detail informations to help use clarify your scenario? (E.g. have many records your report has? which 'bit' of power bi desktop you used? 32 or 64? system memory amount? operate steps...)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi @v-shex-msft,

 

I use the 32 bit version, because the model is build on different MS 32 Acces databases (and Oracle DB.)

Further, 32 GB RAM and Windows Server 2008 R2 Standard. 

Model contains:

 - 13 reports.

 

and:

 

NameRowsColumnsOther
 Table 1 73014 
 Table 2 762 
 Table 3 314 
 Table 4 8916 
 Table 5 1.64126 
 Table 6 93 
 Table 7 62 
 Table 8 101.0196 
 Table 9 1.321.14725Append query; 
 Table 10 66.0839 
 Table 11 398.70739 Append query;  and 2 invoked custom functions

 

 

What would be the best solution? 

 

Kind regards,

BWL

v-shex-msft
Community Support
Community Support

Hi @BWL,

 

it seems like you are exceed to memory limit of 32 bit application, I'd like to suggest you to use power bi desktop 64 bit version to handling your report. 

 

In addition, if you have any advanced operations in query editor(reference query, custom function, combine, merge), you can refer to below link to use buffer function to reduce memory cost of calculation.

Loop Computation in Power Query 

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.