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.

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

curtisp  It is a strange error, happening to me a lot lately.

I think has to do with PQ trying to quess coloumn data type. 

Try to go to query editor formula bar and change in step 'Change Type'  the type of column to 'DateTime' instead of just 'Date', at least this was my issue due to csv data type.

curtisp's avatar
curtisp
Icon for Helper II rankHelper II
10 years ago

konstantinos  Thanks that didn't work though. This error message seems to indicate broad spectrum of issues so lots of specific resolutions.

 

Like you, I haven't ever seen this error over past 2 years working with Power BI/Power Query/Power Pivot. 

 

The quirk here is that the query refreshes successfully when run manually in editor. Itworks when the offending query is run individually, manually, and it works with the Refresh All in query editor too.

 

But it is failing with the error when queries run during report Refresh or Apply Changes. It indicates that there is 1 error in the offending query, but again, there is no error message when run manually.

 

Fails with Apply Changes

 

Fails with Report Refresh

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

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      10 years ago

      Hi curtisp,

       

      Glad to hear the issue has been solved by yourself. :smileyhappy:

       

      In Power BI Desktop, we can enable tracing log via File –> Options –> Diagnostics –> Enable Tracing. When we meet the error when use Power BI desktop, we can go to check detail information. Please take a look at links below:

       

      Power BI Desktop Trace Logs Analyser

      Power BI Diagnostics, Trace Logs And Query Execution Times (Again)

       

      If you have any question, please feel free to ask.

       

      Best Regards,
      Qiuyun Yu

      • curtisp's avatar
        curtisp
        Icon for Helper II rankHelper II
        10 years ago

        These are great thanks, will definitely be using them.