Forum Discussion
Incorrect text loading into the Data Model
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.
It slipped my notice that data in the Model is case insensitive.
Sorry.
3 Replies
It slipped my notice that data in the Model is case insensitive.
Sorry.
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
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:
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://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/
