Retain Data case insensitive from database

[pperumal]

Hello,

Is it possible to retain the case sensitive data from SQL server and treat them as unique record, as i would need them as a primary key column to join it with the fact table. 

xxxxx00000AJinj

xxxxx00000AJINj

xxxxx00000AJLyq

xxxxx00000AJLyQ

xxxxx00000AJqDX

xxxxx00000AJQDx

xxxxx00000AYHuh

xxxxx00000AYHUh

xxxxx00000Bk1oj

xxxxx00000Bk1oJ

Thank you

Priya

[amitchandak · Accepted solution]

@pperumal , These blogs has discussed this

https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

https://www.sqlbi.com/articles/letter-case-sensitivity-in-dax-power-bi-and-analysis-services/