Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error with Data Load from Excel

I tried to import a new table from Excel file and got an error. I ignored it but later while I tried to refresh other tables I got an error message. For the existed tables I got the following messag...
  • edhans's avatar
    7 years ago

    You cannot delete a table in Power Query that has other queries that are dependent on it, so you didn't delete the one that has the error.

     

    You need to go back to that source table and fix the issue that is loading "column35" as a column name. Look in your Excel worksheet for that column in a table.