Sorting different in Power Query desktop vs service

[moltra]

Setup: you have tables created in power query in desktop and power bi service, using the same M code from advanced editor

If you use the Go to Column functionality in both and sort by Name, the sort order is not the same. 

Desktop Power Query		Service Power Query (DF)
Sch Var No		SCHEDULE_ID
SCHED_IMG_ID		SCHED_IMG_ID
SCHEDULE_ID		Sch Var No

Try and see if you can recreate, if not let me know and I will create a custom Query M code that I can share.  

[Anonymous]

Hi @moltra ,

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

Best regards.
Community Support Team_Caitlyn

[moltra]

Power Bi Desktop Release:  August 2023

Product Version:  2.120.731.0 (23.08) (x64)

OS Version:  Microsoft Windows NT 10.0.19045.0 (x64 en-US)

CLR Version:  4.8 or later [Release Number = 533325]

Power Bi Service  version:13.0.21358.58

Client version:2308.2.15305-train

[moltra]

@Anonymous Where you able to reproduce the sorting issue?

[Anonymous]

Hi @moltra ,

Sorry for the late reply , I cannot reproduce it and haven't seen on the internal platform that other engineers have reported this issue and submitted it.

Does this problem still exsited?

Best regards.
Community Support Team_Caitlyn