Forum Discussion

anthonymachado's avatar
anthonymachado
Frequent Visitor
6 months ago
Solved

Remove duplicates bug

I have a table of addresses and I want to run Remove Duplicates on the ID column:   If I filter for address 743786 afterwards, it doesn't appear.   However, if I filter the address be...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    6 months ago

    anthonymachado Probably not a bug. Power Query Editor displays a preview of 1000 rows so for whatever reason the ID is in that 1000 row preview before the dedupe but not after it. Likely a sorting thing going on.

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
6 months ago

Hi anthonymachado ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.