Problem with data transform

[Anonymous]

I have data with capital text in excel like this

item	Code
1	0019000000Mivpu
2	0019000000MivpU

When I import it into Power BI, they are transformed into this like

item	Code
1	0019000000MivpU
2	0019000000MivpU

The last word u in the first code is capitialised then make it similar to the second code which bias data.

Do you have anyway to fix it? 

[TomMartens]

Hey,

as @JosefPrakljacic  already mentioned, this is not possible. I just want add this to provide a little more insight, even if this will not help to solve the "issue" using some kind of workaround.

The Power Query engine uses case-sensitive locale for its operations, whereas Analysis Services Tabular (the storage engine used inside Poewr BI to answer all our analytical questions) uses a case-insensitive local. This means that the latter just stores one item instead of two.
For this the remove duplicates transformation task inside Power Query will treat both strings as different, this can make creating relationships between tables a time-consuming task, until one discovers this behavior.

I assume this behavior will not change in the near future, as I imagine this a huge engineering task.

Regards,

Tom

[JosefPrakljacic · Accepted solution]

Unfortunately I have to tell you that this will not be possible without workarounds. Here is an idea you should upvote.

It's really sad that it still can't be done today.

Workaround -> https://stackoverflow.com/questions/47830288/case-sensitivity-in-power-bi

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Have a nice day!

BR,
Josef