Forum Discussion

NotSteveStephen's avatar
NotSteveStephen
New Member
2 years ago
Solved

Table.Sort

If Table.Buffer is essentially required to make a sorting step work like it is expected, why doesn't Microsoft just make it part of the automated Power Query M code that is generated when a user sorts a table as part of the transformation steps? I have wasted DAYS worth of time trying to find a solution to a problem that didn't exist simply because I didn't magically know that "Table.Buffer" was required to make Table.Sort work like it was expected to work. EITHER make it an auto-generated part of the code OR give us usuers a blessed note, indicator, pop-up, (SOMETHING!) to let us know that Table.Buffer is required to make Table.Sort work as expected. This kind of hidden/necessary work that Microsoft just omits makes me apaplectic.

 

Beyond Frustrated,

 

Stephen