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 be required for analysis purposes.
To remove unwanted columns from the existing tables, please click the Edit Queries option under the Home tab.
How to Remove Columns from Tables in Power BI
Clicking the Edit Queries option opens a new window called Power Query Editor.
- Queries: List of available tables.
- Display the Data (rows and columns) present in the selected table.
- Properties: Selected table Name. You can use this section to rename the Table to be more meaningful.
- Applied Steps: It lists out the steps that we undertake in this Power BI table.
You can select the required column (or Ctrl + Select Columns for multiple columns) and hit the Delete button on your keyboard. For the 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.
Now, you can see that the Product Category Alternative Key column removed from the table. You can see the same under the Applied Steps section.
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.
As you can see, all the other columns will be removed from the category table.
If you want to undo the changes (or revert the changes), then go to the Applied Steps section, and remove the step as we have shown below.
It undoes the steps
Remove Columns from Tables in Power BI – Approach 2
First, select the Column that you want to delete, and then click the Remove Columns option under the Home tab.
Reordering Columns of Power BI Tables
Drag the column and place it as per your requirement. For demonstration purposes, we are dragging the English product category Name from the last position to the first position.
You can see the Category name in the First Position
Whatever changes you make will not affect you until you hit Apply. Let me hit the Close & Apply option under the Home tab.
Please wait until the changes happen. And you can see that the product Category table has only two columns.
