Power Query - Row disappear after expand column

Hello, 

I have been told that this this "this behavior is intentional. Operations like “distinct” and “merge” do not guarantee that an input sort order is preserved. This is because in cases when we run the operation against a relational database, the database itself does not preserve the sort order."

Here is some help text about it: https://docs.microsoft.com/en-us/power-query/commonissues#preserving-sort

Personally I don't quite understand nor argee how this is an intentional behavior, when a preview in one step is showing different values then in the next step.
Seeing steps in the right pane is giving anybody a false understanding of how power query process data: Not in sequentional steps as seen in the steps pane, but in a different hidden way that cannot be predicted.

This feature has already caused me a lot of trouble. So be aware!