How to Fix Microsoft Mashup Engine Resource Access Forbidden Error in Excel
Question details
Users need to resolve a resource access forbidden exception when trying to refresh data.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Refreshing an Excel workbook stored in SharePoint that connects to other SharePoint files via Power Query.
- Observed behavior
- Excel Power Query fails to refresh the workbook and displays a resource access forbidden exception triggered by the Microsoft Mashup Engine.
Before proceeding, ensure you have a stable internet connection and verify with your IT administrator that your account has read access to the main workbook and all referenced SharePoint files.
Update Excel and Clear Data Source Permissions
Use this method to reset your Power Query authentication tokens and ensure your Excel client is fully patched against known SharePoint connection bugs.
Power Query caches your SharePoint credentials to speed up future refreshes. When these credentials expire or corrupt, the Mashup Engine will block access.
Clearing the data source settings forces Excel to request a fresh authentication token from your organization.
Open Excel, navigate to File > Account, click on Update Options, and select Update Now to install the latest build for your selected update channel.
Go to the Data tab on the Excel ribbon, click on Get Data, and select Data Source Settings from the dropdown menu.
In the Data Source Settings dialog, select Global permissions, locate the affected SharePoint URL, right-click it, and choose Clear Permissions.
Try refreshing your Power Query again. When the credentials prompt appears, select Organizational Account on the left side and sign in with your enterprise credentials.

Try WPS Office for a Streamlined Spreadsheet Experience
If you find Excel's Power Query permissions and Mashup Engine errors frustrating, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets and daily tasks without complex enterprise authentication blockers.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the setup file and follow the straightforward on-screen instructions to install WPS Office.
- 3. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files to continue working immediately.

Frequently Asked Questions
What causes the Mashup Engine Resource Access Forbidden error in Excel?
This error typically occurs when the cached login credentials for Power Query expire, if the SharePoint permissions for the connected files have changed, or due to a temporary bug in your specific Excel update channel.
How do I check my permissions for a SharePoint file?
You can open the SharePoint document library in your web browser, select the specific file, click on the details pane or Manage Access, and verify that your organizational account has at least read permissions.
Why does the error persist after clearing data source settings?
If the error continues, your organizational account might be missing access rights to one of the nested background files referenced by the main workbook, or you may need to follow deeper Microsoft troubleshooting guidance for the mashup engine exception.




