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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Vickchan
Regular Visitor

Error in date sort from query editor

Error is found in date sort from query editor in PowerBI desktop.

As a result, i need to perform sort in descending order in data view.

However, i cannot vlookup date correctly for the sebquence steps.

 

My data have 56000 rows, would it be the root cause of date sort error in PowerBI desktop? 

 

pls help

  

date sort in query editordate sort in query editor

Error in date sort in data viewError in date sort in data viewError in date sortError in date sortCorrect date sort after addiional sort in data viewCorrect date sort after addiional sort in data view

1 ACCEPTED SOLUTION
ebeery
Memorable Member
Memorable Member

@Vickchan to my knowledge, you cannot (and should not) rely on the sort order of a table loaded into Power BI from Power Query, due to the way the Vertipaq compression works.

 

See this similar answer here:

https://community.powerbi.com/t5/Desktop/Problem-with-sort-order-changing-after-load-into-model/m-p/... 

 

I would really recommend you take a different approach here, one that doesn't rely on a sort order for downstream processing.  

View solution in original post

1 REPLY 1
ebeery
Memorable Member
Memorable Member

@Vickchan to my knowledge, you cannot (and should not) rely on the sort order of a table loaded into Power BI from Power Query, due to the way the Vertipaq compression works.

 

See this similar answer here:

https://community.powerbi.com/t5/Desktop/Problem-with-sort-order-changing-after-load-into-model/m-p/... 

 

I would really recommend you take a different approach here, one that doesn't rely on a sort order for downstream processing.  

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors