cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
c4rlosmarin
Frequent Visitor

Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

Just so you know, the following is still happening:

http://community.powerbi.com/t5/Desktop/PowerBI-Desktop-CPU-Memory-Hog/m-p/13942/highlight/true

 

And the following workaround did not fixed the issue:

https://social.technet.microsoft.com/Forums/en-US/63159ce7-1252-49ea-891f-d01d7fd4e1be/microsoft-mas...

 

I'm currently using the latest Power Bi Desktop version. My issue is mainly related to querying a 800MB+ XML file, just opening the file, no transformation or any other additional task.

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

Hi @c4rlosmarin,

Multiple calculations(complex measures and calculated columns) in large dataset will eat up much CPU and memory . In your scenario, there are some proposals for you troubleshooting such performance issue.

1. Use the latest version of Power BI Desktop(2.42.4611.901).

2. Untick the following options in your current PBIX file. You can go to File -> Options and settings -> Options->CURRENT FILE(Data Load) to find the options.
1.PNG

3. Follow the guide in this blog to disable Load for these intermediate queries in your PBIX file to save memory.

4. Optimize your data model by following  the tips in the articles below.
  Data Import Best Practices in Power BI
  Power BI Performance Tips and Techniques

5. Use a faster computer with bigger memory would help in your scenario.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

Hi @c4rlosmarin,

Multiple calculations(complex measures and calculated columns) in large dataset will eat up much CPU and memory . In your scenario, there are some proposals for you troubleshooting such performance issue.

1. Use the latest version of Power BI Desktop(2.42.4611.901).

2. Untick the following options in your current PBIX file. You can go to File -> Options and settings -> Options->CURRENT FILE(Data Load) to find the options.
1.PNG

3. Follow the guide in this blog to disable Load for these intermediate queries in your PBIX file to save memory.

4. Optimize your data model by following  the tips in the articles below.
  Data Import Best Practices in Power BI
  Power BI Performance Tips and Techniques

5. Use a faster computer with bigger memory would help in your scenario.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ross27 Advocate I
Advocate I

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

Proposal 2 seems to have fixed the issue for me.  Hard to change these options while your pc is grinding to a halt though!

c4rlosmarin
Frequent Visitor

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

@v-yuezhe-msft: thanks! for some reason I was not getting the notification regarding the availability of a newer version of PowerBi Desktop, I had to manually download it. After that, disabling Background Data and Parallel Loading of Tables fixed the issue.

Highlighted
gary_townsend
Frequent Visitor

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

A larger machine isn't necessarily the solution, its apparent there is a Memory leak in the service and it is exacerbated on systems with the enterprise gateway. We a have a machine with 24GB of memory and the run away memory leak flattened it. The work around was restarting the gateway but that is hardly a good solution. 

gary_townsend
Frequent Visitor

Re: Microsoft Mashup Evaluation Container is killing my box (PowerBI Desktop = CPU + Memory Hog)

A larger machine isn't necessarily the solution, its apparent there is a Memory leak in the service and it is exacerbated on systems with the enterprise gateway. We a have a machine with 24GB of memory and the run away memory leak flattened it. The work around was restarting the gateway but that is hardly a good solution. 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors