cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
c4rlosmarin Frequent Visitor
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
Highlighted
Moderator v-yuezhe-msft
Moderator

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
Highlighted
Moderator v-yuezhe-msft
Moderator

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 Regular Visitor
Regular Visitor

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
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.

gary_townsend Frequent Visitor
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
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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 276 members 3,007 guests
Please welcome our newest community members: