Home Tab in Query Editor: "Remove Columns" option in home tab of query editor in Power BI: Lesson-7 P-19

IT 25.03.2024 0 Comments Add to Reading List

"Remove Columns" in query editor of Power BI: Lesson-7 P-19

In Power BI, you can remove unwanted columns using the "Remove Columns" function within the Power Query Editor. Here's how to access it:

Access to the Power Question Editor:

Import your data: Make sure your data is loaded into Power BI.
OpenPower Query Editor: There are two ways to do this:
- Select a cell in your data table.
- Go to the "Home" tab and click on "Transform Data".

Remove a column:

Click the header of the column you want to remove.
In the "Home" tab of the Power Query Editor ribbon, find the "Remove Columns" section.
Click "Remove Column".

Remove multiple columns:

Hold down the "Ctrl" key and click on the headers of each column you want to remove. You can select contiguous or non-contiguous columns.
In the "Home" tab, go to "Remove Columns" and select "Remove Columns".

Remove all columns except selected columns:

Select the columns you want to keep.
I"Home" tab under "Remove Columns," click the down arrow next to "Remove Columns."
Select "Remove Other Columns". This will remove all columns except the ones you selected.

Important tip:

When using "Remove Other Columns", be careful if you plan to refresh your data frequently. New columns added to the data source may be hidden because they will be treated as "other columns" during the refresh. It is safer to explicitly remove certain unwanted columns.

Lab Work of Remove Columns

"Remove Columns" Menu

1:- Remove Columns (Remove Selecteed Columns)

Import your data: Make sure your data is loaded into Power BI.
OpenPower Query Editor:
- Go to the "Home" tab and click on "Transform Data".
Select required Columns (which you want to delete)

after selecting 4 columns