Forum Discussion

curtisp's avatar
curtisp
Helper II
10 years ago
Solved

Load was cancelled by an error in loading a previous table

How to troubleshoot this "Load was cancelled by an error in loading a previous table" issue?   There are other posts where people get this error but those resolutions are pretty specific to case. ...
Need Help
  • curtisp's avatar
    curtisp
    10 years ago

    Issue resolved with no specific resolution.

     

    I saved offending query M code, deleted query, recreated query using saved M code, and now it works.

     

    I haven't see any info on how to read the Tracing logs. Can anyone say if these would hold relevant information to troubleshoot issues like these?  


    Sometimes the error messages in UI are not enough.

guisin's avatar
guisin
Frequent Visitor
8 years ago

I modified an Excel sheet that was related to my PBI and I received this same error messages.

To fix the issue, I reverted all my changes in Excel and went into each query and update the tables manually one by one. 

 

Hope this helps.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    !Hi!

    Same thing happend to me. I did the process again from zero, the only difference was that I used Direct Query instead of Import Query. I think that as Import Query copies the Data, when your refresh some relationships, updates, deletes or other changes in transformation maybe the refresh trunks something.