Forum Discussion

Jvinc567's avatar
Jvinc567
New Member
1 year ago
Solved

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

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