Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

moltra

Sorting different in Power Query desktop vs service

Submitted by Helper IV on ‎08-24-2023 11:51 AM

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.  

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎08-25-2023 12:44 AM

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
Helper IV
Helper IV
‎08-25-2023 06:14 AM

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
Helper IV
Helper IV
‎08-28-2023 08:30 AM

@Anonymous Where you able to reproduce the sorting issue?

Anonymous
Not applicable
‎09-06-2023 03:21 AM

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

Idea Statuses