PowerBI automatically transforming the imported primary key

[NithinBN]

Hello All, 

I am importing a table having alpha-numeric sequence as a primery key (unique one).

Here i have 2 rows which are only differed by alphabet case. one in Big (caps) 'Y' and another is small 'y'. 

1#BI_x7oKYVfLEe6Src_hoJzMtg ,

1#BI_x7oKyVfLEe6Src_hoJzMtg

In the transform tab it is showing both the rows,

however after I do Close and Apply from Transferd dara view, PowerBI is automatically transferming the  row which contains the small y to capital Y and making both rows  Identical. 

Is there any setting from which I can dissable this kind of behaviour ? 

Thanks in advance !

[gaurav-lakhotia]

Hi @NithinBN , clear the cache memory and try again.

Goto - File >> Options and Setting >> Options >> Under Global >> Data Load >> Clear Cache

[NithinBN]

@gaurav-lakhotia : Still the same behaviour