Remove column from xls

[AlessandroBet]

I'm getting data from xls file and i have created many visuals. Now i have to remove a column from the xls source and refresh the data. This comun is not used anymore indise PBI file

Which is the right process in order to avoid errors after refreshing?

Thanks

[V-pazhen-msft]

@AlessandroBet 

If the columns is not used at all. Simply delete in the excel then manual refresh will not cause any error. 

Best,
Paul

[zoloturu · Accepted solution]

@AlessandroBet ,

If this column was not used in any transformation at PowerQuery steps then you don't need to do anything. Possible types of steps which can contain the name of the column in a transformation are Renamed columns, Pivot/Unpivot, Reordered columns, Transpose etc. Actually, you can go to Advanced Editor and remove the name of this column from all steps. 

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups

[amitchandak]

Refer:

https://community.powerbi.com/t5/Desktop/How-can-I-remove-a-column-I-have-delete-from-data-source/td...

https://xxlbi.com/blog/safely-removing-columns-power-query/

https://blog.crossjoin.co.uk/2015/02/26/handling-added-or-missing-columns-in-power-query/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[ChrisMendoza]

@AlessandroBet -

In https://community.powerbi.com/t5/Desktop/Restoring-Removed-Column-Power-BI-Desktop/m-p/895271#M42918..., it was discussed on how to restore the column.

I believe the safest method to be RIGHT CLICK > DELETE the Column in the Fields List. The presumption of course is you're not referencing the values in the Column otherwise errors would be received.