Power Query Column Data sequence changed when transom into table

[srehman]

Hi Team,

When I am transforming from query editor to Excel sheet as a table in SKU Columns SKU sequence changed it should be same as in Power Query.

usually it is always same as showed in query

Please assist.

Please check attached snapshots

 

[GraH]

Hi, you can add a step with the sort order in PQ. It will force the table in Excel to be the same.
Wild guess here. The preview (always a snapshot) in PQ may have sorted logically in memory, but may spill in source order?
I've seen in queries that the sorting of data is not kept in later steps of the Query. Buffering a table then helps to prevent that.

 

[srehman]

I have tried by adding an extra step of sort but no luck, not sure why this happening.

 

[sandy666]

try to add Index then sort Index ascending and remove Index column
after that load table to the sheet

 

[srehman]

Yes Yes why i could't think like that, awesome Perfect

 

[sandy666]

Glad to help
Have a nice day