on 12 Nov 2018 04:28:30
This is NOT the same as this one:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17235656-case-sensitive-insensitive-option
I'm only asking for ignoring case sensitivity in column headers in PQ. I mean come on who would care the difference between join and Join? Sometimes I have to spend more time catching this than saved by automating in PQ. Yeah for sure we can use M to do similar things, and this is most likely the fault of our database department, but why bother about this anti-feature?
Administrator on 10 Jun 2021 18:30:51
There's not enough to determine the proper use case but the Comparer.OrdinalIgnoreCase operation can ignore the casing of text.