Why does it detect a many to many

[nicolast29]

Hi

I have a table DIM_Salaries from wich a delete duplicate (verify under Excel)

I link it to a fact table FTS_Heures, but it doesnt want a one to many ...... 

here my file

https://1drv.ms/u/s!AoqtZHsX4BzvhL4Cmhkus3rE_JjUIg?e=c8J7nc

[nicolast29]

hi

thanks to your screenshot

i found the error

a space in one of the case

have a nice day

[nicolast29]

Hi thanks

But in the Power Query transformation i have remove duplicate 

That is why i don't understand

[eliasayyy]

Thats weird did you select all columns and pressed remove duplicates? Maybe you have the same id but it has different dimensions in the column 

[eliasayyy · Accepted solution]

hello based on what you sent , it seems you have duplicates therefore , a many to many relationship , but it seems you have a duplicate in your dim salary table 

so maybe just remove duplicates or create a new table 

Values = VALUES(dim_salaries[id])

here is your duplicate