Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
3 years ago
Solved

Why does it detect a many to many

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

 

 

Need Help
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    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 

     

4 Replies

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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 

     

  • nicolast29's avatar
    nicolast29
    Icon for Helper V rankHelper V
    3 years ago

    Hi thanks

    But in the Power Query transformation i have remove duplicate 

    That is why i don't understand

     

    • eliasayyy's avatar
      eliasayyy
      Icon for Memorable Member rankMemorable Member
      3 years ago

      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 

  • nicolast29's avatar
    nicolast29
    Icon for Helper V rankHelper V
    3 years ago

    hi

    thanks to your screenshot

    i found the error

    a space in one of the case

    have a nice day