Load was cancelled by an error in loading a previous table

[nareshambati]

Hi,

I am using the new power BI desktop in Windows 7 Professional.

I have a report that is connected to data in an Excel file in my system. Sometimes, PowerBI is throwing an error when I am trying to refresh the Data using the Refresh button.

Error message: "Load was cancelled by an error in loading a previous table"

The error looks like the one given below (I am unable to upload error snapshot from the system as I couldn't find the option to do so :|)

Refresh

Table_Name1

"Load was cancelled by an error in loading a previous table"

Table_Name2

"Load was cancelled by an error in loading a previous table"

Table_Name3

"Load was cancelled by an error in loading a previous table"

Table_Name4

"Load was cancelled by an error in loading a previous table"

So its not refreshing any table and throwing the above error. I have to make the entire dashboard again with all the formulas If I can't fix this!!

Could someone help me on this?

Thanks 🙂

[dyingod]

Found this as I had the same problem. I have about 60 tables, which get appended into bigger tables - I wonder if this is the problem: "step tables." I say this b/c if I hit refresh on the files individually (not the step tables) they actually refresh but you obviously don't want to have to do that 60 times... defeats the whole point.

[djnww]

I had the EXACT same error message. I have 27 tables. I renamed 2 tables in my PBix file. Then I realised I wanted a different naming convention. Rather than change it in the PBix file as I did previously, I changed it in the Excel input thinking that if I clicked Refresh, the table names would change.

Once I clicked on refresh, the error messages popped up making me think that links to all my tables were broken. I thougth I would have to redo 8 hours of work.

Luckily, I went into the Advanced Editor and renamed the 2 table sources to match Excel. This worked. Problem was gone.

My issue is that Power BI gave me the wrong message. If it said that the issue existed with only 2 tables OR that table the table source was incorrect, then I would immediately know what the problem was. However, getting a message that the load was cancelled for all tables is quite frightening.

- Daniel

[tdwyer]

Indeed a better, more meaningful message would be SO VERY helpful.

[AlexGorev]

We would love to help and address this issue! We need to reproduce this issue first... Can you share your PBIX\Excel files with us?

Thanks,

Alex.

[nareshambati]

Hi Alex,

Thanks for the reply.

I got the solution for this problem. But the reason why it appeared seems strange to me.

Solution:

My problem is, as I mentioned in the 1st post, a dialogue box as given below.

"

Refresh

Table_Name1

"Load was cancelled by an error in loading a previous table"

Table_Name2

"Load was cancelled by an error in loading a previous table"

Table_Name3

"Load was cancelled by an error in loading a previous table"

Table_Name4

"Load was cancelled by an error in loading a previous table"

.....

......

"

But my data has more than 30 tables. Somewhere in the middle of the above error it was written under Table_Name30 as  "Expression.Error: The column 'Col_Name' of the table wasn't found"

Yes, I deleted a column in my source data. But it seems strange to me that changes in one table was responsible for refresh error in all tables!!

Thank you

Regards,

Naresh

[AlexGorev]

Anything special about this column that was filing to load? It would be good for us to reproduce this issue? Can you share the PBIX and Excel file with the repro?

Thanks,

Alex.