PQ loads rows in a different order as the editor

[Anonymous]

I have a PQ table that I've sorted in the editor, but when I load it as a table in the Excel file, the rows come out unsorted. What am I doing wrong? (I am selecting Load to a Table, and Add to the Data model)

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Glad you solved the problem temporarily by yourself, you can also refer to the solutions in these similar threads:

Solved: Problem with order of rows from query editor to ap... - Microsoft Power BI Community

Power Query does not maintain row order while loading to the Table and - Microsoft Community

Hope it helps!

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks. It was actually through an index column that I noticed the table was loading in a pseudo-random order. I managed to get rid of it by unchecking "Add to the data model"

[lbendlin]

You are not doing anything wrong.  There is no guaranteed sort order, neither in Power Query nor in Power BI.  Add an index column if you need deterministic behavior.