How to Fix Power Query Mashup Container High CPU and Memory Usage in Excel
Question details
The user is experiencing excessive CPU and memory consumption caused by the Power Query Mashup Container in Excel, which persists even after updating Office.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Loading, refreshing, or editing data using Power Query in an Excel workbook.
- Observed behavior
- The Power Query Mashup Container process runs continuously and heavily drains system resources (RAM and CPU), causing significant performance degradation.
Before adjusting your Power Query settings, save your current workbook and check if the excessive resource usage happens across all Excel files or is isolated to one specific document.
Disable Background Data Preview Downloads
Stopping Power Query from downloading data previews in the background significantly reduces continuous RAM and CPU consumption.
By default, Power Query attempts to fetch data previews in the background to speed up the editing experience. However, with large datasets or complex queries, this can force the Mashup Container into an endless loading loop, consuming excessive system resources.
Open Excel, navigate to the 'Data' tab on the ribbon, click on 'Get Data', and select 'Query Options' from the dropdown menu.
In the Query Options window, look at the left pane under the 'Current Workbook' section and click on 'Data Load'.
Under the 'Background Data' section, uncheck the box that says 'Allow data preview to download in the background'.
Click 'OK' to save your changes, then save your workbook and restart Excel to clear any active background processes.
Rebuild the Query and Remove Unnecessary Steps
Complex queries with redundant steps or unstable data sources can cause the Mashup Container to loop. Starting fresh can clear underlying cache issues.
Experience Lightweight Data Processing with WPS Office
Struggling with Excel's heavy resource consumption and Power Query lags? WPS Office offers a streamlined, lightweight spreadsheet alternative that handles large datasets smoothly without draining your system's memory and CPU.
Frequently Asked Questions
What is the Power Query Mashup Evaluation Container?
It is a background process used by Microsoft Excel to evaluate and execute Power Query transformations, establish connections to data sources, and generate data previews for the Power Query Editor.
Why does the Mashup Container use so much memory?
High memory usage usually occurs when Power Query is actively downloading large data previews in the background, processing highly complex query steps, or struggling to maintain a connection to an unstable external data source.
Does reinstalling Office fix the Power Query high CPU usage?
Reinstalling or updating Office often provides little to no improvement because the high resource usage is typically tied to the specific query design, workbook cache settings, or background preview configurations rather than corrupted application files.
