Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 value.
Hi lbendlin,
Thanks for the update, reason being in sorting against a date column, I have duplicates in my main key column I would like to remove duplicates so I do not get issues with my 1:n relationships downstream.
I guess if I am using the file to populate the dataflow I will need to cleanse my data before utilising it, but this functionality was working without issue prior to Fabric Feb update, wonder what MS had done to now cause sorts to fail if not formatted correctly.
Thanks for the update, reason being in sorting against a date column, I have duplicates in my main key column I would like to remove duplicates so I do not get issues with my 1:n relationships downstream.
This still does not require sorting. Do a Table.Distinct on your intended key column and Power Query will randomly pick the row to keep.
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.