Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
Willborn
Advocate III
Advocate III

Why does PBI find's duplicates where there are none?

‎09-07-2016 07:02 AM

Hi there!

 

I struggle with a strange behaviour: I like  to connect two tables in the data model. The one has a key-column with unique values, the other multiples (1:n). Now PBI don't let me build this connection, as it finds duplicates in the column where there are none.

 

Crazy - when I filter the list using "keep duplicates" - it shows me values - but they are not duplicates!!??

 

This_are_not_duplicates_but_PBI_found_them_as_duplicates.JPG


Does anyone has a suggestion?

 

Thanks, Patrick

 

Key
300020
300030
300035
300040
300042
300050
300052
300053
300054
300056
300058
300060
300070
300069_BC
300069_OBC
300220
300220_MF
300230
300230_MF
300235
300235_MF
300240
300242
300250
300252
300253
300254
300254_MF
300256
300258
300260
300270
300299_BC
300299_OBC
300020_BC
300020_OBC
300035_BC
300035_OBC
300030_BC
300030_OBC
300054_BC
300055
300069_BC
300069_OBC
300220_BC
300220_OBC
300230_BC
300230_OBC
300235_BC
300235_OBC
300299_BC
300299_OBC
300254_BC
300255
300369_BC
300369_OBC
300315
300320
300330
300335
300340
300342
300350
300352
300353
300354
300356
300360
OI0059_BC
OI0059_OBC
OI0020_BC
OI0020_OBC
OI0030_BC
OI0030_OBC
OI0035_BC
OI0035_OBC
OI0054
OI0054_BC
OI0055
300500_CSS
S10010Y10
S10010Y15
S10010Y20
S10010Y25
S10010Y49
S10010Y30
S10010Y35
S10010Y40
S10010Y50
S10010Y55
S10010Y60
S10010Y65
S10010Y70
S10010Y75
S10010Y80
S10010Y99
300500_CS
300500_CSS
300500
300600
Message 1 of 7
3,106 Views
0
1 ACCEPTED SOLUTION
Seth_C_Bauer
Community Champion
Community Champion
In response to Willborn

‎09-07-2016 07:32 AM

@Willborn Please see this image... the first and last are the same value. Maybe you have a space at the end of one of them in your originating set when you are pulling distinct?

dups.JPG


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Message 6 of 7
3,525 Views
0
6 REPLIES 6
Seth_C_Bauer
Community Champion
Community Champion

‎09-07-2016 07:08 AM

@Willborn There are duplicates in your key column... It's even in your screenshot #9 and #10 are the same.

300500_CSS

Are you saying that these aren't part of your initial data set that you loaded?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Message 3 of 7
3,105 Views
0
Willborn
Advocate III
Advocate III
In response to Seth_C_Bauer

‎09-07-2016 07:29 AM

It seems that for PBI "300500_CSS" is the same as "300500_CS" and the same as "300500" !?

Message 5 of 7
3,100 Views
0
Seth_C_Bauer
Community Champion
Community Champion
In response to Willborn

‎09-07-2016 07:32 AM

@Willborn Please see this image... the first and last are the same value. Maybe you have a space at the end of one of them in your originating set when you are pulling distinct?

dups.JPG


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Message 6 of 7
3,526 Views
0
Willborn
Advocate III
Advocate III
In response to Seth_C_Bauer

‎09-07-2016 07:39 AM

Argh,... the system won ;o)

 

Thanks for showing me the trees in the wood... and sorry for taking your time!

 

Regards Patrick

Message 7 of 7
3,091 Views
0
Willborn
Advocate III
Advocate III
In response to Seth_C_Bauer

‎09-07-2016 07:26 AM

Hi Eno

 

The full data i've loaded is the one I pasted into the code.

300500_CSS is there only once...

 

When I open the file in Excel and search for duplicates, it tells me "no duplicates found"

 

The screenshot is the result of the PBI Desktop Function "keep duplicates". I really don't know wher he takes them...

The import file has 100 lines only.

Message 4 of 7
3,101 Views
0
Willborn
Advocate III
Advocate III

‎09-07-2016 07:03 AM

Hi there!

 

I struggle with a strange behaviour: I like  to connect two tables in the data model. The one has a key-column with unique values, the other multiples (1:n). Now PBI don't let me build this connection, as it finds duplicates in the column where there are none.

 

Crazy - when I filter the list using "keep duplicates" - it shows me values - but they are not duplicates!!??

 

This_are_not_duplicates_but_PBI_found_them_as_duplicates.JPG


Does anyone has a suggestion?

 

Thanks, Patrick

 

Key
300020
300030
300035
300040
300042
300050
300052
300053
300054
300056
300058
300060
300070
300069_BC
300069_OBC
300220
300220_MF
300230
300230_MF
300235
300235_MF
300240
300242
300250
300252
300253
300254
300254_MF
300256
300258
300260
300270
300299_BC
300299_OBC
300020_BC
300020_OBC
300035_BC
300035_OBC
300030_BC
300030_OBC
300054_BC
300055
300069_BC
300069_OBC
300220_BC
300220_OBC
300230_BC
300230_OBC
300235_BC
300235_OBC
300299_BC
300299_OBC
300254_BC
300255
300369_BC
300369_OBC
300315
300320
300330
300335
300340
300342
300350
300352
300353
300354
300356
300360
OI0059_BC
OI0059_OBC
OI0020_BC
OI0020_OBC
OI0030_BC
OI0030_OBC
OI0035_BC
OI0035_OBC
OI0054
OI0054_BC
OI0055
300500_CSS
S10010Y10
S10010Y15
S10010Y20
S10010Y25
S10010Y49
S10010Y30
S10010Y35
S10010Y40
S10010Y50
S10010Y55
S10010Y60
S10010Y65
S10010Y70
S10010Y75
S10010Y80
S10010Y99
300500_CS
300500_CSS
300500
300600

 

Message 2 of 7
3,086 Views
0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

View All