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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Duplicate Value

Hi everyone,

 

For some reason when I see my data in power query is as follow

 

First link for the power bi file

 

https://intercorpretail-my.sharepoint.com/:u:/g/personal/aleksei_diaz_irdigital_pe/ES5Jjq68cepOqaVxB... 

 

LInk for the data 

https://intercorpretail-my.sharepoint.com/:x:/g/personal/aleksei_diaz_irdigital_pe/EdhDTwLo5ztBmfB_Y...

 

Capturecc.PNGCapturecccc.PNG

2 ACCEPTED SOLUTIONS
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

basically power query seems data as characters meaning OTTOWARE <> Ottoware so power query understand they are 2 different things, if you want to merge those 2 rows as part of a same data you need to do some tranformation such as making all the letters upper or lower case letters and them group them, that would do the trick. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

Power Query is case sensitive. So whenever you would try to group or doing other transformation, power query will treat both values differently. However when you make a visualation in the desktop both values should be treated as one. So can you check if there are some spaces after the text "Ottoware"? This I think can be the only reason here.

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

2 REPLIES 2
Jimmy801
Community Champion
Community Champion

Hello @Anonymous 

 

Power Query is case sensitive. So whenever you would try to group or doing other transformation, power query will treat both values differently. However when you make a visualation in the desktop both values should be treated as one. So can you check if there are some spaces after the text "Ottoware"? This I think can be the only reason here.

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

StefanoGrimaldi
Resident Rockstar
Resident Rockstar

basically power query seems data as characters meaning OTTOWARE <> Ottoware so power query understand they are 2 different things, if you want to merge those 2 rows as part of a same data you need to do some tranformation such as making all the letters upper or lower case letters and them group them, that would do the trick. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.