microsoft.mashup.container.loader.exe Disk usage - no query is loading

Question

microsoft.mashup.container.loader.exe Disk usage - no query is loading

Jakub Dusek 101

Hello,

I have noticed that often my excel file with multiple queries is consuming a lot of Disk usage.
No query is loading at that time, Query editor is not open at that time.

How is that possible?

Warm regards,
Jakub

Grant Brimhall 1 Reputation point

2021-08-29T04:15:27.71+00:00

Hi:

What is the purpose of this executable? We have built several excel files with OData sources from D365 databases. Often upon refreshing those databases, we will get an error in the middle of the refresh (anywhere between 3-5 minutes after we clicked refresh) that says "OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host." And then even after dismissing the error by clicking [OK], these processes still continue to consume CPU and Memory (as the original poster Jakub has suggested).

How many container loaders can run at once? And would these have anything to do with the Odata transport connection error we experience?

Thanks.

2 answers

Your answer

Grant Brimhall 1 Reputation point

2021-08-29T04:15:27.71+00:00

Hi:

What is the purpose of this executable? We have built several excel files with OData sources from D365 databases. Often upon refreshing those databases, we will get an error in the middle of the refresh (anywhere between 3-5 minutes after we clicked refresh) that says "OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host." And then even after dismissing the error by clicking [OK], these processes still continue to consume CPU and Memory (as the original poster Jakub has suggested).

How many container loaders can run at once? And would these have anything to do with the Odata transport connection error we experience?

Thanks.

Answer 1

Ehren (MSFT) 1,781 Microsoft Employee

Power Query pre-calculates the preview results for each step of each query. It does this behind the scenes, so that's likely what you're seeing.

You can disable this behavior by unchecking "Allow data previews to download in the background" in the Options dialog. However, this can sometimes result in slower performance when clicking around your queries in the PQ Editor. It just depends on how many queries/steps you have and the nature of your queries.

Jakub Dusek 101 Reputation points

2021-06-16T10:55:05.927+00:00

Hello,
I had this disabled when taking the screenshot
The disk usage was permanent - I returned to the PC after several hours and the disk usage was still high
Ehren (MSFT) 1,781 Reputation points Microsoft Employee

2021-06-16T17:17:54.773+00:00

Was "Allow data previews to download in the background" disabled when you opened the file (i.e. the entire time you had the xlsx file open), or only after opening it? I'm wondering if the evaluations running in the background may have been kicked off when the setting was enabled.
Jakub Dusek 101 Reputation points

2021-06-23T23:13:37.033+00:00

Hello, yes - I was aware of that option before.

Anyway, I solved that problem by moving queries to a newly created file.
Ehren (MSFT) 1,781 Reputation points Microsoft Employee

2021-06-23T23:21:32.793+00:00

Hm, ok. In that case, I have no idea what might be causing the disk usage. If you're able to create a shareable file (without any sensitive data) that reproduces the issue, please feel free to share it with us via a OneDrive link. Even if you delete some or all of the queries, perhaps the issue will still happen, since pasting the same queries in a new file doesn't lead to the same behavior.

Answer 2

Corcoran 1

Turn off fuzzy match! Worked for me.

Share via

microsoft.mashup.container.loader.exe Disk usage - no query is loading

2 answers

Your answer