If your query has columns you don't need, remove them. You can select one or more columns, and then either remove the selected columns or remove the unselected columns.
Consider the difference between removing a column and removing other columns. When you choose to remove other columns and then refresh your data, the query might not detect new columns added to the data source since your last refresh operation because those columns are considered other columns when the Remove Column step runs again. This situation doesn't occur if you explicitly remove a column. The new columns added since the last refresh appear in Data Preview.
To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information, see Create, load, or edit a query in Excel.
Do one or more of the following:
- To remove a single column, select the column you want to remove, and then select Home > Remove Columns > Remove Columns.
- To remove several columns, select the columns by using Ctrl + Click or Shift + Click. The columns can be contiguous or discontiguous.
- To remove all columns except the selected column, select one or more columns, and then select Remove Other Columns.