Forum Discussion

Sergiy's avatar
Sergiy
Resolver II
7 years ago
Solved

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 i...
Need Help
  • Sergiy's avatar
    Sergiy
    7 years ago

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

    Sorry.

HMasekowitz's avatar
HMasekowitz
New Member
7 years ago

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's avatar
Sergiy
Resolver II
7 years ago

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-insensitive-option

 

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-load-not-maintaining-case-sensitive-data?forum=powerquery

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