how to delete the duplicated row in Power Query

[yanzhao_LBS]

For example I have a table like this

what i want is record 2 and 4 are totally same ,i want to delete one. is there any function for this?

[Ritaf1983 · Accepted solution]

Hi @yanzhao_LBS 
You should select all your columns (with mouse + CTRL) and then click right << remove duplicates.

Unfortunately, I am out of the limit of images that I can add to discussions, so I recorded my screens you can download the video from the link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ahmedx]

pls see my video

https://1drv.ms/v/s!AiUZ0Ws7G26RimMehIfjvupNUfXx?e=L5EHFe

[yanzhao_LBS]

Thanks it works well.

[Ritaf1983]

Glad to help 🙂

[yanzhao_LBS]

and do you know how to highlight (find out) which line is the duplicated one?

[Ritaf1983 · Accepted solution]

Hi again 🙂
You can add a column that can concatenate all the columns and see the id this new column has duplicates 

Power query has great profile tools. please refer to 

https://learn.microsoft.com/en-us/power-query/data-profiling-tools

I have also updated the video with recorded screens.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @yanzhao_LBS 
You should select all your columns (with mouse + CTRL) and then click right << remove duplicates.

Unfortunately, I am out of the limit of images that I can add to discussions, so I recorded my screens you can download the video from the link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.