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

[euniceyau]

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

[kcantor]

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.