Fix Power BI Refresh Error: Load Was Cancelled
Question details
The user needs to resolve a data refresh failure in Power BI caused by a previous table loading error.

- 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.
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.
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.
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.
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'.
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.
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.

Check Gateway Connections and Data Drivers
Ensure that your on-premises data gateway is online and the required OLEDB/ODBC drivers are correctly installed for cloud-based dataset refreshes.
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.

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.




