Load was cancelled by an error in loading a previous table

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