Deleting columns from appended manual Excel tables

[redalert787]

Hello, 

I am using several excel tables as my source of data in power BI. I have appended the tables into one table to have one single vision of sales. I would like to delete one of the unnecessary tables from this appended query. 

I looked up some videos and articles. I understand the best way is to go to the "advanced editor" in power query and delete the column from there. My one problem that I have is in the appended table I can't seem to find the list of columns in the advanced editor whereas in all the others I can find it. 

Can anyone give any help with this? 

[JoeBarry]

Hi @redalert787 

In the Applied Step part of the query click on the settings symbol and remove the Excel you don't want. just highlight and click delete

Thanks

Joe

If this post helps, then please Accept it as the solution

[redalert787]

Hi Joe, 

Sorry I don't think I was very clear. I meant I want to delete a column from all of the tables and make sure that the refresh functioned in excel. I don't want to delete an entire table. 

Normally in the advanced editor, there is the "changed type" step that includs all the columns but in the appended table this does not exist. Therefore, if I remove the columns from the excel source data I think the refresh would give me an error. 

[JoeBarry · Accepted solution]

Correct, if you remove it at the source, this will break the query. Then in the Appended table, just delete the column after the Appended table step.