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
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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors