Cedric Charlier shows how to ignore case when running Table.Distinct in Power Query:
Note that at the top of the table, I’ve twice the value ADO.NET, once with uppercase and once lowercase for the “Net” part. If I try to apply a
Table.Distinct, the two values will be considered as distinct and one of them won’t be removed.Will it be an issue? If this your key and it’s part of a model where this key is part of one side of a one-to-many then it will be an issue.
Read on for the solution.