BI Desktop Not Recognizing Difference Between Upper and Lower Case Letters

Yikes!  While I completely the 'case insensitivity' thing is ridiculous (much like the 'additivity' issue), the solution in your video is well beyond my BI/PowerQuery kung fu - especially given the sheer number of alphanumeric combinations in my data. Was really hoping there would be a relatively straightforward way to do this - surely there's a way in PowerQuery to take a column and either convert it's existing values to unicode, or create a new column based on the original and parse those values into unicode. It's becoming increasingly clear I may be indulging in wishful thinking. Perhaps I need to investigate doing the conversion on the front end with SQL.