Hide Columns in Dataset

[StuartSmith]

Is there a way to hide columns in a data set?  I have a large dataset table that currently only need to use some of the columns and therefore would be nice to hide the unwanted columns to reduce the visual dataset table size.  I am aware I can delte columns, but I may want to use these columns in the furture and therefore hiding columns is a tidier approach.

[amitchandak · Accepted solution]

@StuartSmith , If you do not need at all then remove in edit query/data transformation mode.

Else right click on the column name and Hide in Data/Visual Tab

[PaulDBrown]

@StuartSmith 

Another way to "hide" columns, besides the methods already suggested, is to select the columns you want Power Query to load into the model. If you need these in the future, you can just go into Power Query and re-select the columns you left out originally:

[Anonymous · Accepted solution]

You can remove columns from dataset in two ways:

1. Go to transform tab and right click on column name and click remove column option or you can do ctrl + click  on different to remove multiple columns.
2. If you dont want to remove them come back to main power bi window and go to Modeling Tab. Right click on a column and select Hide in Report view. Now the column will no longer be visible on visualization tab.

[amitchandak · Accepted solution]

@StuartSmith , If you do not need at all then remove in edit query/data transformation mode.

Else right click on the column name and Hide in Data/Visual Tab