Forum Discussion
Power Query Causing File To Freeze At Regular Intervals
Hoping someone can offer some advice... I have an excel file that handles a large amount of data via the Power Query Editor and puts it into a series of pivot tables. I use power query because the...
Use the resource monitor to check which activities write to disk at the same time. your periodic freezes may also be caused by swapping activities.
Thanks Ibendin.
Apologies i hadnt used the resource monitor before (just the task manager). I have gone in and had a look.
When i refresh the data i get a higher CPU usage from Microsoft.Mashup.Container.Loader.exe. In Disk i also get much higher System write usage.
When the freezing happens i dont see Microsoft.Mashup.Container.Loader.exe there. Excel CPU usage spikes massively though and flips between Running and not responding throughout the freeze. Things then settle down again once the spinning blue icon goes away and everything is fine for 15mins until it starts again.