Forum Discussion
Jvinc567
1 year agoNew Member
Order of imported data
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:
Power Query does not guarantee a sort order. You need to bring your own sorter.
1 Reply
- lbendlinSuper User
Power Query does not guarantee a sort order. You need to bring your own sorter.