Merged Values Change Before and After Query

Hi could you try first sorting those fact and dim tables based on the key columns before trying to merge those tables

Then use Table.Buffer to freeze the data afterb sorting

Then merge them

If there are transformations to the data try doing those before the merge happens

Hi Anonymous ,

The real question is: Why is it important that your rows stay in the same order? The Vertipaq engine will only muddle them up again as soon as you apply the query to the model.

Pete

And sort order is not define in PowerQuery, except after a sort. As was stated by Imke in the solution of the post you referred to in your post.