Forum Discussion
Power ParticipantURL link changes capital letters to regular ones after loading Power Query. Why?
Hi AliceW ,
"And I couldn't figure out what you mean by the blank."
I mean insert a space before a1.
Actually for this problem, there are currently two possible solutions:1. Use M language
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/
2. Modify value
Just like I did before, insert the corresponding characters in the column value to distinguish the column value.Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power ParticipantThe plot thickens.
I actually have the code as a separate column ('Internal Code'), except it has 3 additional letters after the 'right' first 15 ones.
I've tried trimming it with LEFT('Internal Code', 15), and it ALSO capitalized all letters except the first one.
What is going on?
And I couldn't figure out what you mean by the blank.. I've tried creating a new column as CONCATENATE(BLANK(),'Internal Code'), but I still got capitalized letters.
I've also, in Power Query, tried creating a new column by trimming the 'Internal Code' to the first 15 characters, and it also capitalized them.
That's a weird behaviour of my favorite software, guys.
Community SupportHi AliceW ,
"And I couldn't figure out what you mean by the blank."
I mean insert a space before a1.
Actually for this problem, there are currently two possible solutions:
1. Use M language
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/
2. Modify value
Just like I did before, insert the corresponding characters in the column value to distinguish the column value.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.