Remove Unwanted RANDOM Rows from Data

[AmberJane]

I have a list of tickets I am pulling from a ticketing system into Power BI using ODATA. The report I am building will be sent to a client each month and will need to be "Groomed" before sending. 

Sometimes there is bad data/tickets that don't need to be in this report. There is no condition that I can power query off of as these will be one offs based off the monthly review.

I found a youtube video that worked but only seems to let me remove one row. I want to be able to remove multiple. Any suggestions. 

I added an index column and then used advanced editor: 

#"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 0, 1, Int64.Type),
#"Remove Row" = Table.RemoveRows(#"Added Index",83)
in
#"Remove Row"

[AmberJane · Accepted solution]

@Anonymous received an error:

Error: Expression.SyntaxError: Token ',' expected.

#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"

[AmberJane · Accepted solution]

@Anonymous received an error:

Error: Expression.SyntaxError: Token ',' expected.

#"Added Index" = Table.AddIndexColumn(#"Removed Top Rows", "Index", 0, 1, Int64.Type)
#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({4,5}, [Index]))
in
#"Remove Row"

[Anonymous · Accepted solution]

Hi @AmberJane , You just missed a comma at the end of the previous step. 

Regards,

Jing

[AmberJane]

Oh my how embarrassing!! it worked thank you so much. 

[Anonymous]

Hi @AmberJane 

If you are sure which rows are unwanted by their Index numbers, you can try this 

#"Remove Row" = Table.SelectRows(#"Added Index", each not List.Contains({1,3,4,83}, [Index]))

Put all unwanted index numbers in a list {}. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!