Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |