Showing results for 
Search instead for 
Did you mean: 

Load was cancelled by an error in loading a previous table error when refresh the power BI

I encountered an error when refreshing my power BI which data source is excel stored on Personal one drive.  Error message are:

OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D. and Load was cancelled by an error in loading a previous table.  can you urgently help how i can reslove it  thanks

Community Champion
Community Champion

You will need to open the pbix file that you have stored and attempt to refresh it from there. If you receive an error, go to edit queries and make what ever changes you  need for the specific error you are receiving. You will see the query with the error flagged. Then, republish after you correct the error.

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors