Has anyone else experienced that records sorted in Power Query do not appear in the same order as when loaded and viewed in Power Pivot? Where does Power Pivot get it's sort order from? There does seem to be a pattern with many levels but I cannot decipher it.