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
Dear All,
I'm in the same situation right now, but I can't solve the issue with the solution suggested in this post.
Can you please help me to solve the issue? I basically deleted four columns from my excel file, but deleting the column from the query brings me to the issue "the column wasn't found".
I don't know how to solve it, I'm available to share the query information with you, I really need to fix the problem.
Thank you,
Alessandro