Power Query Problems

How to Fix Excel Query Will Not Run or Data Model Cannot Be Accessed

Huma Ashraf Ch Oct 16, 2026 869 views

Question details

The user is unable to run an Excel query or access the workbook's Data Model to process data.

How to Fix Excel Query Will Not Run or Data Model Cannot Be Accessed

Product: Microsoft Excel
Device & OS: not provided
Scenario: Refreshing a data query, editing a query connection, or attempting to access the Data Model in an existing workbook.
Observed behavior: The query fails to execute, or the Data Model becomes inaccessible, typically due to missing information regarding permissions, connection configurations, or workbook corruption.

Before you start

Verify that your network connection is active and carefully write down the exact error message Excel provides, as it points directly to whether the issue is a permission, connection, or model failure.

Solution 1Recommended

Check Data Source Settings and Clear Permissions

Use this solution to resolve authentication errors or connection blocks preventing Power Query from running.

Often, a query fails to run because the cached credentials for the external data source have expired, changed, or become corrupted. Clearing these permissions forces Excel to establish a fresh connection.

Open Data Source Settings

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

Clear Existing Permissions

Locate the problematic data source in the list, select it, and click 'Clear Permissions' at the bottom. Confirm the action when prompted.

Re-authenticate the Query

Close the settings window and click 'Refresh All' on the Data tab. Excel will prompt you to enter your credentials again. Provide the correct login details to restore the connection.

Check Data Source Settings and Clear Permissions

Connection Restored: If the query runs successfully after re-entering credentials, the issue was strictly authentication-based.

Solution 2

Enable the Power Pivot Data Model Add-in

Apply this fix if you receive errors specifically stating the Data Model cannot be loaded or accessed.

Free Microsoft Office alternative

Experience Smooth Data Analysis with WPS Office

If Microsoft Excel's Power Query and complex Data Models are causing persistent loading errors, consider switching to WPS Office. It provides a lightweight, fast, and highly compatible alternative for standard data processing, pivot tables, and everyday spreadsheet tasks without the heavy overhead of complex COM add-ins.

1. Download the App: Visit the official WPS website and download the free WPS Office installer for your operating system.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx files directly without losing your standard formatting or formulas.
3. Analyze Data Effortlessly: Highlight your datasets and use 'Insert PivotTable' to summarize and analyze your information quickly.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight architecture prevents memory overload during large data processingBuilt-in advanced Pivot Table capabilities for fast, error-free data analysisCompletely free to use with an intuitive, familiar tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say the Data Model cannot be accessed?

This typically occurs if the Excel file is corrupted, there is a memory limitation (especially in 32-bit versions of Excel), or the Power Pivot COM add-in has been disabled by the system after a crash.

How do I find the exact error message for my Excel query?

Open the 'Queries & Connections' pane on the right side of your screen. Hover your mouse over the query displaying a yellow warning triangle, and click 'View Errors' in the pop-up to see the specific diagnostic message.

Will clearing the Power Query cache fix loading issues?

Yes, clearing the cache can resolve unexpected query failures. You can do this by going to Data > Get Data > Query Options, selecting the 'Data Load' section, and clicking 'Clear Cache'.

Excel & Data Problems