Forum Discussion
Choose columns vs remove columns
Best practise is to choose the columns that you want to keep, and don't make any reference to unwanted columns. That way if the data source were to change for one of those unwanted columns (deleting or renaming), it won't break your model - nothing more annoying than having a refresh break because of a source change for a column you weren't even interested in. Moreover, this also protects your model from the appearance of new (and unwanted) columns in your data source. If you're getting down to your preferred columns by explicitly removing the unwanted ones, then if a new unwanted column is added, it flows out into your data model until you update the code to add it to the remove list.
- danextian4 years agoSuper User
I agree with pk_Ross . You want to choose only those that are relevant to your data model, those that you want to keep. You don't want unnecessary columns to suddenly pop-up in your model. Do Remove if you expect that those columns will not be deleted or renamed in the future.