How to Fix Microsoft Mashup Engine Error During Excel Refresh
Question details
The user experiences a recurring Microsoft Mashup Engine error when trying to refresh data in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing external data sources connected via Power Query in Excel.
- Observed behavior
- A Microsoft Mashup Engine error interrupts the data refresh. The issue temporarily resolves after clearing global permissions but recurs frequently.
Before applying fixes, note the exact error message and identify the specific data source failing to refresh. Ensure your Excel application is updated to the latest version.
Verify Data Source Credentials and Privacy Levels
Updating specific connection credentials and privacy levels often resolves Mashup Engine conflicts without having to clear all global permissions repeatedly.
Clearing all global permissions forces Excel to request credentials for every connection, which is not a permanent solution. Identifying and fixing the specific failing connection's privacy level will stabilize the refresh process.
Navigate to the 'Data' tab in the Excel ribbon, click on 'Get Data', and select 'Data Source Settings'.
Select 'Global permissions' at the top of the dialog box to view all saved data source connections.
Locate the specific data source causing the refresh error, select it, and click the 'Edit Permissions' button.
Ensure the login credentials are correct. Then, update the Privacy Level (e.g., from 'None' to 'Organizational') to prevent firewall conflicts and click 'Save'.

Clear the Power Query Cache
Clearing the cache can fix corrupted temporary data that triggers the Mashup Engine error during refreshes.
Try WPS Office for Seamless Data Management
If you are experiencing recurring Power Query and Mashup Engine errors in Microsoft Excel, consider switching to WPS Office. WPS Office offers a free, lightweight, and highly compatible spreadsheet tool with a familiar interface, ensuring your data management tasks run smoothly without heavy resource demands.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx or .csv files seamlessly to continue your work.

Frequently Asked Questions
What causes the Microsoft Mashup Engine error in Excel?
This error is typically caused by a corrupted Power Query cache, conflicting data privacy levels, outdated Excel versions, or mismatched connection credentials during the data refresh process.
Will clearing global permissions delete my data?
No, clearing global permissions will only remove saved login credentials and privacy settings for your external data sources. Your actual data and formulas in Excel will remain intact, but you will need to re-enter your credentials upon the next refresh.
How do I update Excel to fix Power Query bugs?
Go to the 'File' menu, select 'Account' (or 'Office Account'), click on 'Update Options', and select 'Update Now'. This ensures you have the latest patches that may resolve underlying Mashup Engine issues.
Can I use WPS Office to run Microsoft Power Query scripts?
WPS Office supports standard Excel files and robust data processing tools like PivotTables, but it does not run Microsoft's proprietary Power Query Mashup Engine (M code). It is highly recommended as a lightweight alternative for standard data analysis without these complex engine dependencies.




