Forum Discussion

euniceyau's avatar
euniceyau
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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...
kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

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.