Power Query Table.Distinct is removing all rows

[cr731]

I'm trying to remove duplicates in my table in Power Query and when I use the Table.Distinct function, it removes all rows of my table so I end up with an empty table. How is this possible?

My table is very basic with columns like

Code	Description
EB123	Description 1
EB1234	Description 2
EB123	Description 1

<tbody>
</tbody>

Is there anything that can cause this behavior?

 

[cr731]

I found that if I use Table.Buffer before the Table.Distinct step, it works.

Can anyone explain why this would be necessary?