Forum Discussion

curtisp's avatar
curtisp
Icon for Helper II rankHelper 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.

kharveyausten's avatar
kharveyausten
Regular Visitor
8 years ago

I'm using MS Accss as backend datasource and I fixed by chnagin the Power BI Options; basically Access in some situations cannot handle "Parallel Loading" enabled but is fine with SQL Server datasource.

 

Try this:

 

Options

Data Load (this report sectioon)

Untick "Enable parallel loading of tables"

 

Also editing or deleting a column in a referred table can causes issues; I deleted a column and got another error, I put the column back in and all was OK; only if column is being referred to.