Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Retain the same order when Import Excel Data to PBI Desktop

Hi,

How do I keep the same order while importing Excel data?

 

I am new to PBI.  How to tell what sort order is being used in the table view?  Added a custom index, not sure how to make it as a primary sort order.  Is there any other way to approach this?

 

Thanks!

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Sorting data in Power Query is extremely costly. Avoid it if you can. Add your index column in Excel, and then let Power BI do the sorting in memory.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Sorting data in Power Query is extremely costly. Avoid it if you can. Add your index column in Excel, and then let Power BI do the sorting in memory.