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...
Need Help
  • edhans's avatar
    edhans
    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.

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hello, 

I try to start power query in excel and it crashes.

I have Microsoft 365 family, Windows 10.

 

i don’t understand why I’m able to use Legacy procedures but not the classic way, is there any option I should check? 

I can’t find a solution.