cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Re: "System.OutOfMemoryException"/Desktop keeps crashing

@v-piga-msft and @fletchb did we get a solution or explanation to this error??

Highlighted
Post Patron
Post Patron

Re: "System.OutOfMemoryException"/Desktop keeps crashing

@rkocher  i have same error in pbi service refresh thru gateway? any solutions?

Highlighted
Advocate I
Advocate I

Re: "System.OutOfMemoryException"/Desktop keeps crashing

@reddy_powerbi @fletchb

 Not sure if a solution or a happy coincidence. Did a hard reset on my computer, cleared %temp% files, and then opened a new instance of Power BI and haven't had the same issue occur.

 

Best of luck! 

Highlighted
New Member

Re: "System.OutOfMemoryException"/Desktop keeps crashing

Hello friend,

 

Did you get the solution to the issue you are facing?

As I am also facing the issue "System.OutOfMemoryException".

 

Please help in case you have the solution to this.

 

 

Thanks in advance

Vishnu

 

 

Highlighted
Advocate I
Advocate I

Re: "System.OutOfMemoryException"/Desktop keeps crashing

@vish678 Try fully uninstalling Power BI and reinstalling. Or try uploading the file to service and then redownloading it to desktop

Highlighted
Helper IV
Helper IV

Re: "System.OutOfMemoryException"/Desktop keeps crashing

I don't know if its the same issue as I found, but we got the same result when trying to read from an Excel file containign a table. Turns out the source system had created the table with all the empty columns in the Excel sheet as columns; over 16,000 of them! Once the spurious columns were deleted from the table it worked fine.

Highlighted
Helper III
Helper III

Re: "System.OutOfMemoryException"/Desktop keeps crashing

I am getting crashes in just about every PowerBI doc I open in the last 3-4 days. I haven't changed anything hardware wise. Before these 3-4 days it was running fine. The problem appears to occure where I am either adding some calculated columns, sometimes when trying to publish (although it does publish successfully it then creashes out with the reason of systemmemory).

I too am using 32bit to ensure it is compatible with 32bit Office that our company use (I don't know why head of IT in companies insist on 32bit, it's at every company I go to). The crashes happen even before 100% of the RAM is taken up.

I have tried the docs on a completely different machine (granted, also with extra RAM, but shouldn't make a difference in 32bit mode?) and it runs perfectly fine, just like it use to on this system.
Highlighted
Advocate III
Advocate III

Re: "System.OutOfMemoryException"/Desktop keeps crashing

I was experiencing the same issue and resolved it by increasing the size of the paging file by following these steps: 

 

1. Open file explorer. 

2. Right click on "My Computer"/"This PC" and select properties.

3. Select "Advanced System Settings" from left-navigation panel. 

4. Click "Advanced" tab. 

5. Click "Settings" in "Performance" section. 

6. Select "Adjust for best performance" in "Visual Effects" tab. 

7. Click "Change" in "Advanced" tab. 

8. Uncheck "Automatically manage paging file size" 

9. Select the drives (preferably SSD) and under custom size mention the size in multiple of thousands to set the size. I set minimum to 16000 and maximum to 32000

 

This worked for m. 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors