cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
curtisp Helper II
Helper II

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.

 

I  have modified date field formats which might have lead to this error but believe I have returned everything back to pre-error state to no avail.

 

I can successfully run the queries in question individually manually in the Power Query view.  

 

So no query errors are apparent. It is only when I try to refresh entire Power BI report or all queries that this error arises.

 

How to troubleshoot this?

 

 

 

load cancelled.png

1 ACCEPTED SOLUTION

Accepted Solutions
curtisp Helper II
Helper II

Re: Load was cancelled by an error in loading a previous table

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.

View solution in original post

15 REPLIES 15
curtisp Helper II
Helper II

Re: Load was cancelled by an error in loading a previous table

Oh this is interesting.  I found the source of the error message by some sluething about.  I looked at one of the date fields in the query edit view and tried to get it show all date values and got this very hidden error message at bottom of date picker list. 

 

 

[DataFormat.Error] We couldn't parse the input provided as a Date value.

 

 

aha here is error.png

 

 

This is odd because upon inspection of original data files (csv files) all of the values in this date column are in fact dates.

konstantinos Memorable Member
Memorable Member

Re: Load was cancelled by an error in loading a previous table

@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.

Capture.PNG

Konstantinos Ioannou
curtisp Helper II
Helper II

Re: Load was cancelled by an error in loading a previous table

@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

pending changes.png

apply query changes fails.png

 

Fails with Report Refresh

report refresh fails.png

curtisp Helper II
Helper II

Re: Load was cancelled by an error in loading a previous table

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.

View solution in original post

Moderator v-qiuyu-msft
Moderator

Re: Load was cancelled by an error in loading a previous table

Hi @curtisp,

 

Glad to hear the issue has been solved by yourself. Smiley Happy

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
curtisp Helper II
Helper II

Re: Load was cancelled by an error in loading a previous table

These are great thanks, will definitely be using them.

fcipriano
Frequent Visitor

Re: Load was cancelled by an error in loading a previous table

Hi,

 

I experienced the same error. This happens when you try to remove a column/table that is related to another table. I removed the relationship first on the tables and applied the changes.

 

Hope this helps.

 

Regards,

Carmine
New Member

Re: Load was cancelled by an error in loading a previous table

 
Highlighted
Carmine
New Member

Re: Load was cancelled by an error in loading a previous table

I am new to PoweBI, but I got this error quite soon.

I was notice I had a query with a warning. In those query I had an incorrect DAX formula. Once I removed the error(I just delete the formula) the load went smoth again. I guess it's a general error due to some incorrect sintax.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors