Others

Fix Power BI Refresh Error: Load Was Cancelled

Amos GikundaAmos Gikunda Oct 9, 2026 872 views

Question details

The user needs to resolve a data refresh failure in Power BI caused by a previous table loading error.

How to Fix Power BI Refresh Error: Load Was Cancelled
Product
Power BI
Device & OS
not provided
Scenario
Refreshing a Power BI report containing external OLEDB or ODBC data sources.
Observed behavior
The refresh process aborts entirely, displaying the message "Load was cancelled by an error in loading a previous table" alongside a specific database or driver error.
Before you start

Ensure you have administrative or edit access to the underlying data sources and that your Power BI Desktop is updated to the latest version before modifying query settings or gateway configurations.

Solution 1Recommended

Identify and Fix the Root Table Error

Locate the exact table causing the initial failure to resolve the cascade error that is stopping the entire data refresh process.

Because Power BI loads tables in parallel, a failure in one query forces the system to cancel all other pending queries to maintain data integrity. You must isolate the original error rather than focusing on the 'Load was cancelled' symptom.

1
Open the detailed error log

In Power BI Desktop, click on 'View Errors' in the yellow ribbon or expand the error details popup after the failed refresh to see the list of all table queries.

2
Locate the first failed query

Scroll through the error list and look for the specific query that triggered an OLEDB, ODBC, or credential error, ignoring the tables that simply state 'Load was cancelled'.

3
Verify credentials and permissions

Navigate to the 'Home' tab on the ribbon, click 'Transform data', then select 'Data source settings'. Choose the failing data source, click 'Edit Permissions', and ensure your credentials are fully authenticated.

4
Refresh the specific table

Inside the Power Query Editor, right-click the problematic table in the left pane and select 'Refresh Preview'. This will confirm if the underlying schema or data type issue is resolved before you apply changes to the whole model.

Identify and Fix the Root Table Error
Tip: If you are unable to resolve the specific OLEDB/ODBC error, posting the exact error code in the Microsoft Fabric Community forums can provide driver-specific troubleshooting.
Free Microsoft Office alternative

Manage and Analyze Your Data with WPS Office

While Power BI handles complex enterprise data visualization, WPS Spreadsheet provides a lightweight, free, and highly capable alternative for everyday data processing, reporting, and analysis. Experience seamless compatibility with Microsoft Excel formats without the hefty subscription fees.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats for smooth data integration.Built-in pivot tables, advanced formulas, and visualization tools for efficient daily data analysis.Lightweight installation that runs swiftly on Windows, Mac, and Linux.Free to use with a familiar, user-friendly tabbed interface ensuring zero learning curve.
QA img-9

Frequently Asked Questions

Why does one table error cancel the entire Power BI load?

Power BI typically evaluates and loads tables in parallel to save time. If one table fails due to a credential mismatch, missing column, or schema issue, the engine immediately cancels the entire refresh operation to prevent incomplete or mismatched data relationships from being published to your final report.

How do I find which data type is causing the OLEDB error?

Open the Power Query Editor, select the table identified in your error log, and click 'Keep Errors' under the 'Keep Rows' menu in the Home tab. This isolates the exact rows and columns containing invalid data types or format mismatches so you can clean the data.

Can I ignore errors and force the rest of the tables to load?

You cannot ignore errors during a standard model refresh. However, you can prevent a specific problematic table from breaking the entire report by right-clicking that query in the Power Query Editor and unchecking 'Enable load' until you are able to fix the underlying issue.