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.
Clicking 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 more meaningful.
- Applied Steps: It lists out the steps that we undertake on this table.
TIP: 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.
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 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 removed from the category table.
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.
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 Remove Columns option under the Home tab.
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.
You can see the Category name in the First Position
Whatever the changes you made will not effect until you hit Apply. Let me hit the Close & Apply option under the Home tab.
Please wait until the changes made.
And you can see that the product Category table has only two columns.