Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

why after saving and closing power Query, The order is different

Hi,

 

I did some group in power query, and sort Asset ID as 1st sorting, G/L Date as 2nd sorting, everything looks great (Picture 1). After I save and close powe rquery, the order of G/L date is different(picture 2). Anyone can tell me what happend, and how to address the issue?

 

thank you!

 

babyjb123_1-1652828283287.png

 

babyjb123_0-1652828217597.png

 

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

After your sort step, use Table.Buffer to lock them in order. 

--Nate

View solution in original post

Anonymous
Not applicable

3 REPLIES 3
Anonymous
Not applicable

After your sort step, use Table.Buffer to lock them in order. 

--Nate

Anonymous
Not applicable

Hi Nate,

I thought it will work, but it didn't. Could you please help to check if I did it right? After I used Table.Buffer, and save and close PQ, the order of the date is still messed up.  😞

 

babyjb123_0-1652889467822.pngbabyjb123_1-1652889489455.png

 

Anonymous
Not applicable

You are awsome!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.