Power Query Mashup Containers at 0% of processor, network, and disk

Question

I have an excel Power Query report with a surprising bug. All of the mashup engine processes have no processor footprint, but exist. The only fix I have right now is to end these processes. The new mashup containers are created and the report continues to load. Why might these dead processes occur? I am not comfortable sharing the code of the problem query here.

Below is the task manager. Per the highlight, those four standing processes are at 0% before I ended them and new instances began.

Answer 1

You may look at these three articles from Chris Webb's BI Blog:

1. Monitoring Power Query Memory Usage With Query Diagnostics In Power BI
2. Speed Up Power Query In Power BI Desktop By Allocating More Memory To Evaluation Containers
3. Speed Up Power Query In Power BI Desktop By Increasing Or Decreasing The Number Of Evaluation Containers