Power Query editor refresh running slowly, Microsoft Mashup Container running even when idle
Results 1 to 1 of 1

Thread: Power Query editor refresh running slowly, Microsoft Mashup Container running even when idle
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2009
    Location
    Pittsburgh
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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 by Vaslo; Jul 3rd, 2019 at 10:32 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •