Others

Fix Power BI Loading Blocked by Failures with Other Queries in Excel

Emma BrownEmma Brown Nov 3, 2026 870 views

Question details

The user encounters a 'Loading blocked by failures with other queries' error when attempting to refresh data from an Excel workbook.

How to Fix Power BI Loading Blocked by Failures with Other Queries in Excel
Product
Power BI and Excel
Device & OS
not provided
Scenario
Refreshing an Excel data source in Power BI Desktop.
Observed behavior
The refresh process is halted with an error message indicating that another query or data source failed, blocking the current query from loading.
Before you start

Ensure your Power BI Desktop is updated to the latest version and verify that the source Excel workbook is not currently open or locked by another application.

Solution 1Recommended

Diagnose and Fix the Initial Failed Query

Identify the root cause of the refresh failure by locating the specific query that failed first in the Power Query Editor.

Power BI evaluates multiple queries simultaneously. When one query fails due to credential issues, privacy settings, or broken links, it blocks dependent or parallel queries from loading.

Resolving the first failing query usually clears the error for all other blocked queries.

1
Open Power Query Editor

Launch Power BI Desktop and click on the 'Transform Data' button on the Home ribbon to open the Power Query Editor.

2
Locate the Failed Query

Look at the Queries pane on the left side. Scroll through the list and locate the query displaying a yellow warning triangle or an error icon.

3
Review Applied Steps

Click on the failed query and examine the 'Applied Steps' pane on the right. Click the step with the error to read the specific failure details (e.g., invalid credentials or missing columns).

4
Update Credentials or Settings

If the error is related to credentials, go to File > Options and settings > Data source settings, select your Excel file, and click 'Edit Permissions' to update your login details.

5
Apply and Refresh

Once the specific error is resolved, click 'Close & Apply' on the Home tab to retry refreshing your data model.

Diagnose and Fix the Initial Failed Query
Check Privacy Levels: If your queries merge data from multiple sources, ensure that the Privacy Levels in 'Data source settings' are configured correctly, as mismatched privacy levels can also trigger refresh failures.
Free Microsoft Office alternative

Prepare and Edit Your Source Data Easily with WPS Office

While resolving Power BI data import errors, having a reliable spreadsheet editor is essential. WPS Office is a powerful, lightweight, and completely free alternative to Microsoft Office that allows you to manage, clean, and format your Excel source files with zero compatibility issues.

  1. 1. Open Your Data: Launch WPS Spreadsheet and securely open your raw Excel data files.
  2. 2. Clean and Format: Use built-in formulas, duplicate removal, and formatting tools to ensure your data is ready for Power BI.
  3. 3. Save as Standard Format: Save your optimized file as a standard .xlsx format to ensure seamless data refresh without loading errors.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats used in Power BILightweight installation ensures fast loading of large datasetsFamiliar spreadsheet interface with zero learning curveBuilt-in robust data cleaning and formatting tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power BI say 'Loading blocked by failures with other queries'?

This error occurs because Power Query attempts to process multiple tables concurrently. If a single query fails due to missing columns, broken file paths, or credential issues, Power BI automatically stops loading other dependent or parallel queries to prevent data model inconsistencies.

How do I find exactly which query failed first?

Click 'Transform Data' to open the Power Query Editor. Look at the Queries pane on the left side of the window. The query that is actually causing the problem will have a yellow warning triangle or a red error icon next to its name.

Can clearing data source permissions fix this loading error?

Yes, if the initial query failure was caused by authentication issues. You can clear permissions by going to File > Options and settings > Data source settings. Select the data source, click 'Clear Permissions', and then refresh the data to re-enter your credentials.

Does moving my Excel file cause the loading blocked error in Power BI?

Yes. If the file path of your source Excel workbook changes, the query will fail to find the data. This failure will subsequently block all other queries from loading until you update the file path in the Data source settings.