Forum Discussion
Solved
deleted columns in excel source
Hi, I use Power BI Desktop with an excel file as source. I had to delete one column in the excel table and now Power BI always give me an expression.error to tell me that it doesn't find the colu...
You have to delete the specified column from all the steps in Query editor. Let's have a look into Advanced editor in Home ribbon and delete all parts of code where the specified column is used - not the steps but only the sections connected to the column.
That's it.
Regards.
Pavel
I am having a similar issue but I already deleted the column from an appended. The "source" tables are all the same (I didn't delete anything). The only change is the column deleted from the appended table.
Is there some way to restore that column?
I have tried going through the Advaced Editor to "restore" the append forumula to the default which doesn't seem to work.