Cant create 'One to many' relationship

[Mornagli]

Hello, I have servel tables, In one of the tables i have column with text format with values that contains letters and numbers
(e.g AB123, sd0001, sd012), when i try to create relationship with another table with this column i only get 'many to many'.

In that column i dont have duplicates values, blanks or NULL cells, And if i add index to every cell(AB123 1, sd001 2, sd012 3), then MPBI give me the option - 'One to many', So i think that maybe MPBI pasre some value as something else(e.g MPBI see 001 as 01),
but i dont want to change the data, what is the problem and how can i get One to many?

[Greg_Deckler · Accepted solution]

@Mornagli Pay attention to casing. Power Query treats upper and lower cases as different from one another but DAX does not.

[Anonymous]

I de-duped my data set, but it is still insisting on a many-to-many relationship.

[AlB]

Hi @Mornagli 

Can you share the pbix?

Or at least the two columns you are using to create the relationship?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Mornagli]

Hi @AlB 
I cant share the data, but the column that i need to be with 'One' instead with 'Many' that make the problem is :
- Text format
- Without duplicates
- Without null or blank cells
- couple of cells with language that is not english(maybe it couse problems..)

I think that mabye its some parse problem because as i said, if i add to each value an uniqe number - It is possible to get the "one to many"

here some examples:

- Q10080

- Q10079

- C3ANCLQWE

- C3ANCLQVE

Thank you.

[Icey · Accepted solution]

Hi @Mornagli ,

Just as what @Greg_Deckler mentioned, please pay attention to case. One example:

The most direct way, you can go here to find if there are duplicated values:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler · Accepted solution]

@Mornagli Pay attention to casing. Power Query treats upper and lower cases as different from one another but DAX does not.