Forum Discussion
titou64
9 years agoNew Member
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...
- 9 years ago
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
PavelR
9 years agoSolution Specialist
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
titou64
9 years agoNew Member
Thanks for your help ! It works ! :smileyhappy: