Desktop is changing a letter case on its own.

[Anonymous]

Hello

have some very strange behaviour in an import model. When I import a table a letter keeps getting capitalised. This only happens when viewing the model, if I look at the data in power query it is like the source as expected.

the circled value is how this appears in the data source with a lower 'a'. there are no steps being applied in power query it is just a straight import.

but when I view the data in a table control suddenly the letter a in this field gets capitalised. This came to light when doing a count description, returning 3 when it should be 2, as most of our comparisons are textual this could have major implications. This doesn't happen in direct query mode. strangely the 'a' in 'Short Description' is not affected.

[v-joesh-msft]

Hi @Anonymous ,

Here is a post that is very similar to your situation, and provides a corresponding solution, you can look at it:

https://community.powerbi.com/t5/Desktop/Switching-from-Query-Editor-capitalizes-random-letters/td-p/596453

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.