Forum Discussion
Sorting in Dataflow
Hi, I am having an issue with a DateTime column I converted to Date to sort to get rid of duplicates in another column. DataFormat.Error: We couldn't parse the input provided as a DateTime va...
ISO8601 format is generally preferred to reduce ambiguity.
Sorting in Power Query must be avoided as it is an extremely costly operation, and usually not required in the downstream process.