Power Query editor refresh running slowly, Microsoft Mashup Container running even when idle

Vaslo

Board Regular
Joined
Jun 3, 2009
Messages
156
All,

I have cleaned up a group queries that transform some data for monthly FP&A analysis we do. Without tedious detail we essentially take two exports and combine them into one, and then pull from each previous query (M-Code starts with a source like #"Join Pricing Data") to pull from that particular query. The setup works well and refreshes aren't too bad and well within my tolerant range. Where I have problems is when I go in to edit a query, the preview in the editor is VERY SLOW. In addition, I keep hearing my fan spin up and noticed that there are several instances of "Microsoft Mashup Evaluation Container", and at times, even when I haven't touched the keyboard in a while, those containers start using a ton of resources sometime to 100% CPU.

Does anyone know of possible causes (and fixes) to slow editor preview refreshes? Is it related to the heavy Evaluation Container usage? I have tried a few suggestions like putting some Table.Buffer onto some of the steps and have unchecked the Data Load setting in the Options pane. I am at a loss and everything working great except these editor refreshes holding me back while trying to make adjustments to the M statements.

Thanks!
 
Last edited:

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

BDeBock

New Member
Joined
May 13, 2020
Messages
2
Office Version
365
Platform
Windows
Wow, exactly what I've been struggling with! Did some nice querying, combining some data, applying a custom formula on a subquery, feeding that back into the final result and then... all of a sudden everything is taking a huge amount of time when performing simple assignments in that same final result. It's driving me mad!
 

Vaslo

Board Regular
Joined
Jun 3, 2009
Messages
156
So the main problem I had was that I was trying to pull data from a Shared Server and for some reason it was horribly slow. Drove me mad as well. I had to move everything over to my PC (which was far from ideal) but now it works like a charm. I've started using SSIS as well which is really really fast but have to do SQL to get what you want. I have had Power Query code in the past that was very slow, particularly when doing certain actions across lots of columns. Hope you can figure out what is wrong.
 

BDeBock

New Member
Joined
May 13, 2020
Messages
2
Office Version
365
Platform
Windows
I'm replicating Excel behavior and found out in a thread that that is not what Power Query is intended for. So now I've just pulled the information into my file, generated a few tables and will do the rest/hard work via Power Pivot.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,593
Messages
5,487,749
Members
407,609
Latest member
Chrissie1970

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top