Problem with text data import

[iDream]

Hello!

In my SQL data base i have table "Products" with text field "IDRef" used as unique ID. In this table i have 2 rows:
1) IDRef = "rcWQ5rqngEgR4RnL/cDEMw=="
2) IDRef = "rcWQ5rqngEgR4RnL/cDEmw=="

Difference in one symbol at first row "M", at second "m"(fourth from right).

In power query module all ok, but when i import data in model(in power bi desktop) program transform them to:
1) IDRef = "rcWQ5rqngEgR4RnL/cDEMw=="
2) IDRef = "rcWQ5rqngEgR4RnL/cDEMw=="

So after import they become euqal.


Any idea how to fix this issue?

[ImkeF · Accepted solution]

Unfortunately the 2 engines powering Power BI are handling case sensitivity differently. You have to create another key:

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