Transform Data - Remove Multiple Rows

[Bankesy26-_]

Good morning,

Thanks to everyone who has answered my recent queries on this forum, they've really helped me get going with Power Bi.

So I'm hoping somebody can also tell me what I'm missing here, before I import a spreadsheet to work with I gather the data can be transformed but I can't see how to remove multiple rows.  Like, I don't want rows 1-10 but can't see how to take them away in one go.

I'm sure there's something simple that I'm not seeing so if anybody knows that would be appreciated.

Thanks in advance

[FreemanZ]

hi @Bankesy26-_ 

this is done in power query, like:

https://www.spguides.com/remove-rows-in-power-query-editor/

[danextian]

Hi @Bankesy26-_ 

In home tab there are options to remove/skip/keep rows

Beyond what is available from the GUI, I would create conditional/custom column to that will determine whether a rows is to be kept or not based on certain conditions. This column is to be used to filter the table.

[vojtechsima · Accepted solution]

Hello, @Bankesy26-_ ,

once you load your file,  go to Remove Rows and then write the number: