Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NithinBN
Helper II
Helper II

PowerBI automatically transforming the imported primary key

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

 

NithinBN_2-1696231251461.png

In the transform tab it is showing both the rows,

NithinBN_3-1696231300997.png

 

 

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. 

NithinBN_4-1696231386590.png

 

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

 

Thanks in advance !

 

 

2 REPLIES 2

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

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

gauravlakhotia_0-1696231797503.png

 

@gaurav-lakhotia : Still the same behaviour

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.