Order of imported data

[Jvinc567]

I am importing project information from Asana into Power Bi, but when I get the data into Power Bi the project steps come in a seemingly random order.

I need the data to come in the same order in which it is in Asana, and I have tried to set a helper column for this, but this is not sustainable as the project steps will change. Any help would be much appreciated!

Asana order: 

Power Bi order: 

[lbendlin · Accepted solution]

Power Query does not guarantee a sort order. You need to bring your own sorter.