Power Query Problems

How to Fix Microsoft Mashup Engine Resource Access Forbidden Error in Excel

Nimra MalikNimra Malik Nov 2, 2026 870 views

Question details

Users need to resolve a resource access forbidden exception when trying to refresh data.

How to Fix the Microsoft Mashup Engine Resource Access Forbidden Error in Excel
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 you start

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.

Solution 1Recommended

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.

1
Update Microsoft Excel

Open Excel, navigate to File > Account, click on Update Options, and select Update Now to install the latest build for your selected update channel.

2
Access Data Source Settings

Go to the Data tab on the Excel ribbon, click on Get Data, and select Data Source Settings from the dropdown menu.

3
Clear SharePoint Permissions

In the Data Source Settings dialog, select Global permissions, locate the affected SharePoint URL, right-click it, and choose Clear Permissions.

4
Sign In with Organizational Account

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.

Update Excel and Clear Data Source Permissions
Verify File Permissions: If the error continues after signing in, double-check that your account has explicit access not just to the main workbook, but to every individual SharePoint file referenced in your queries.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
  2. 2. Install the Software: Run the setup file and follow the straightforward on-screen instructions to install WPS Office.
  3. 3. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files to continue working immediately.
Seamlessly open, edit, and save Microsoft Excel (.xlsx, .xls) formats.Free, lightweight, and features a fast installation process.Familiar user interface that requires zero learning curve.Built-in data tools suitable for most daily spreadsheet reporting needs.
microsoft office alternative - wps office

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.