Remove Columns from Tables in Power BI

What are the steps required to Remove Columns from Tables in Power BI with an example? In general, the data that we load from the source might have some columns that may not require for the analysis purpose.

How to Remove Columns from Tables in Power BI

To remove unwanted columns from the existing tables, please click the Edit Queries option under the Home tab.

Remove Columns from Tables in Power BI 1

Clicking Edit Queries option opens a new window called Power Query Editor.

  1. Queries: List of available tables.
  2. Display the Data (rows and columns) present in the selected table.
  3. Properties: Selected table Name. You can use this section to rename the Table to more meaningful.
  4. Applied Steps: It lists out the steps that we undertake on this Power BI table.
Remove Columns from Tables in Power BI 2

You can select the required column (or Ctrl + Select Columns for multiple columns) and hit the Delete button from your keyboard. For the Remove Columns from Tables in Power BI demonstration purpose, we remove a few columns from the DimProductCategory table.

Remove Columns from Tables in Power BI – Approach 1

Please select the column that you want to remove. Next, right-click on it and select the Remove option from the context menu.

Remove Columns from Tables in Power BI 4

Now, you can see that the Product Category Alternative Key column removed from the table. And you can see the same under the Applied Steps section.

Remove Columns from Tables in Power BI 5

Remove Other Columns: Use this option to remove all the columns from the table except the selected columns. For the demonstration purpose, I am selecting the Product Category Key and Product category name. Next, right-click and select the Remove Other Columns option from the context menu.

Remove Columns from Tables in Power BI 6

As you can see, all the other columns removed from the category table.

Remove Columns from Tables in Power BI 7

If you want to undo the changed (or revert the changes), then go to the Applied Steps section, and remove the step as we have shown below.

Remove Columns from Tables in Power BI 8

It undoes the steps

Remove Columns from Tables in Power BI 9

Remove Columns from Tables in Power BI – Approach 2

First, select the Column that you want to delete, and then click Remove Columns option under the Home tab.

Remove Columns from Tables in Power BI 10

Reordering Columns of Power BI Tables

Drag the column and place it as per your requirement. For the demonstration purpose, we are dragging the English product category Name from the last position to the first position.

Remove Columns from Tables in Power BI 11

You can see the Category name in the First Position

Remove Columns from Tables in Power BI 12

Whatever the changes you made will not effect until you hit Apply. Let me hit the Close & Apply option under the Home tab.

Remove Columns from Tables in Power BI 13

Please wait until the changes made.

Remove Columns from Tables in Power BI 14

And you can see that the product Category table has only two columns.

Remove Columns from Tables in Power BI 15