Then I want to remove a single value, so the next step = List.RemoveItems(myList,, referenced it from the other query, and my result calculated immediately. This list appears as one of my query steps when I 'preview' it. For example, I have a list of 10 text values taken from an Excel table. I'm wondering if has to do with how I sometime organize my code.ġ) Power Query constantly uses all of several CPU cores, calculating something, even if I'm not waiting for a result.Ģ) In task manager I can sometimes see that the Power Query threads ('40.exe') are nearly idle, while Excel.exe is using 100% of one core for tens of minutes - even though at most I'm looking values in a few parameter tables that don't contain more than a couple dozen cells.ģ) Some steps take extremely long to calculate, even though the operations involved are trivial. I've created a few reasonably complex M queries and have started running into some severe performance issues. I dont see it say 'Running background query' on the Mac. On the Excel 206 for Mac, there is no Table Tools and Query Tools menu, just a Table menu with a refresh button, but the refresh doenst do anything. Windows 10 Not Fitting On Screen | How To Fix I built a query in Excel 2016 for windows using Get and Transform data and when I refresh, I see the status on the bottom task bar.
