Incorrect text loading into the Data Model

[Sergiy]

I've encountered an incorrect data loading of Power Query results into the Model.

For some unknown reasons lower case letters get converted to upper case ones and vise versa.

The picture below illustrates this behaviour:

I experience the issue each time when a text column has more than one values of the same text with different letters’ case(upper/lower).

The data source I used for testing: OData feed, Excel file, “Enter Data” table. Whatever the data source is the bug could be reproduced.

The sample file:

https://www.dropbox.com/s/sxtg5mfdzxbd75d/UpperLowerCase_bug.pbix?dl=0

Hope someone from Microsoft team pay attention to this issue.

[HMasekowitz]

I see the same problem with my data.

How did you solve the problem???

I tryed a lot but did not solve it.

BR Henrik

[Sergiy]

For the time being I left it as it is.

If I am forced to do something I'll probably think in a direction of generating a numeric unique key in Power Query so that later use it in Data Model relationships.

You can vote for the idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17235656-case-sensitive-insensiti...

I have great doubts this idea will ever be implemented since it was voiced for in 2016 and now is 2019. More over, DAX is case insensitive by design (since 2009).

We are not the first who faced the problem:

https://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210

https://social.technet.microsoft.com/Forums/en-US/f12496b0-7424-44e7-a384-a08694595899/power-query-l...

https://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/

[Sergiy · Accepted solution]

It slipped my notice that data in the Model is case insensitive. 

Sorry.