Forum Discussion
Vickchan
4 years agoRegular 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 st...
- Anonymous4 years ago
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:
I would really recommend you take a different approach here, one that doesn't rely on a sort order for downstream processing.
Anonymous
4 years agoNot applicable
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:
I would really recommend you take a different approach here, one that doesn't rely on a sort order for downstream processing.