Uploaded September 2023 | Updated September 2026, 3 days ago
Power query tutorial for beginners where I'll show you how you can use the keep rows or remove rows option where you can keep top or bottom or range of rows and similarly using the remove rows option you an remove top or bottom rows as per your needs. This keeping or removing rows is very helpful when you can want to test the data with only limited no of rows so that proof of consent (POC) development time is lower.
Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com
In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standard and professional looking business dashboards.
Power BI Tutorials Google Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Dataset - tinyurl.com/yd65vnf3
#powerbi #datacleaning #datatransformation #powerquery
What is Power query keep rows and remove rows feature?
The Power Query Keep Rows and Remove Rows features allow you to select the rows that you want to keep or remove from a table. This can be useful for cleaning up data, removing duplicate rows, or filtering out rows that do not meet certain criteria.
To use the Keep Rows feature, you can follow these steps:
Open the Power Query Editor.
Select the table that you want to work with.
Click on the Home tab.
In the Transform group, click on the Keep Rows button.
In the Keep Rows dialog box, select the criteria that you want to use to keep rows.
Click on the OK button.
The rows that meet the criteria will be kept, and the other rows will be removed.
To use the Remove Rows feature, you can follow these steps:
Open the Power Query Editor.
Select the table that you want to work with.
Click on the Home tab.
In the Transform group, click on the Remove Rows button.
In the Remove Rows dialog box, select the criteria that you want to use to remove rows.
Click on the OK button.
The rows that meet the criteria will be removed, and the other rows will be kept.
Here are some of the criteria that you can use to keep or remove rows:
Top Rows: Keep the top N rows.
Bottom Rows: Keep the bottom N rows.
Range of Rows: Keep a range of rows, specified by the row numbers.
Duplicates: Keep all rows, remove duplicates.
Errors: Keep all rows, remove rows with errors.
Custom: Use a custom expression to determine which rows to keep or remove.
I hope this helps! Let me know if you have any other questions.
Power query tutorial for beginners where I'll show you how you can use the keep rows or remove rows option where you can keep top or bottom or range of rows and similarly using the remove rows option you an remove top or bottom rows as per your needs. This keeping or removing rows is very helpful when you can want to test the data with only limited no of rows so that proof of consent (POC) development time is lower.
Want to take your power bi dashboarding skills to next level? then join my advance power bi dashboard training, email me - abhishek.agarrwal@gmail.com
In this training I cover 10 advance dashboards with lot of dax and visualization configuration for standard and professional looking business dashboards.
Power BI Tutorials Google Sheet - docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Dataset - tinyurl.com/yd65vnf3
#powerbi #datacleaning #datatransformation #powerquery
What is Power query keep rows and remove rows feature?
The Power Query Keep Rows and Remove Rows features allow you to select the rows that you want to keep or remove from a table. This can be useful for cleaning up data, removing duplicate rows, or filtering out rows that do not meet certain criteria.
To use the Keep Rows feature, you can follow these steps:
Open the Power Query Editor.
Select the table that you want to work with.
Click on the Home tab.
In the Transform group, click on the Keep Rows button.
In the Keep Rows dialog box, select the criteria that you want to use to keep rows.
Click on the OK button.
The rows that meet the criteria will be kept, and the other rows will be removed.
To use the Remove Rows feature, you can follow these steps:
Open the Power Query Editor.
Select the table that you want to work with.
Click on the Home tab.
In the Transform group, click on the Remove Rows button.
In the Remove Rows dialog box, select the criteria that you want to use to remove rows.
Click on the OK button.
The rows that meet the criteria will be removed, and the other rows will be kept.
Here are some of the criteria that you can use to keep or remove rows:
Top Rows: Keep the top N rows.
Bottom Rows: Keep the bottom N rows.
Range of Rows: Keep a range of rows, specified by the row numbers.
Duplicates: Keep all rows, remove duplicates.
Errors: Keep all rows, remove rows with errors.
Custom: Use a custom expression to determine which rows to keep or remove.
I hope this helps! Let me know if you have any other questions.
