cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pabeader
Helper V
Helper V

HELP! Microsoft Mashups are eating my memory

Ever since I updated to the new Report Server, my PBI server is getting killed by Mashups.  It looks like they are not being released after use and just keep building up until I start to loose functionality.  Paginated reports start getting 403 errors.

Eventually I stop and restart the Report server and that buys me another few hours.  

 

8 processor and 24G memory.  Used to be 12G and that was just fine.

9 REPLIES 9
AbhiSSRS
Impactful Individual
Impactful Individual

You may look at this new article from Chris Webb and see if manipulating below 2 registry settings can help here!

ForegroundEvaluationContainerCount

MaxEvaluationWorkingSetInMB 

 

https://blog.crossjoin.co.uk/2021/06/13/speed-up-power-query-in-power-bi-desktop-by-increasing-or-de...

 

Not sure how those are related to Report Server.  As far as I can see, the problem is that the number of Mashups just keeps growing.  Well betond the 20 that is mentioned in the article.  I've seen as many as 50 or more.  It's like it fires one up and then forgets it's there. 

 

Here is what I get after less than an hour.

pabeader_0-1623760360873.png

 

So, we upped the memory to 64G.  Guess what?  It's now taking 50+  At least it hasn't completely stopped the server but this is ridiculous.  No changes in workload, no additional reporting or users.  Before the update we were running along on 12G after the update, 64g is hardly enough.

 

I just don’t know what else to try.

This looks like it might be worth a support request? https://support.microsoft.com/

Sure would be nice, but no.  Company would rather go back to paper, I swear!

 

 

I still don't see how this reply applies to a Report Server issue....

The mashup container runs as part of the report server and is responsible for handling the power query work for the model. The behavior of the model settings can impact how power query inside the mashup is working.  I am not sure it can help, but just an idea to try. Could be the enhanced meta data feature? https://docs.microsoft.com/en-us/power-bi/report-server/whats-new

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.