Forum Discussion

imahmood1's avatar
imahmood1
Frequent Visitor
8 years ago

Managing Relationships

Hi There,   I have two appended tables ( i also have more with the same information) with most of the columns being the same e.g. both have Name, Year, Reg etc. However I am unable to create a rela...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago
Hello, I Hope Power BI will not support "Many -to- Many" Relationship. SO remove the duplicates from one of the tables and try and let us know still has issues.
  • imahmood1's avatar
    imahmood1
    Frequent Visitor
    8 years ago

    Hi

     

    I'm not sure I understand. If i delete the duplicates from one how will it create the relationship between both tables if there are no similar values?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi,

       

      If i understand from your image the common column from both tables are "Name".

      Even though the column names from both tables are availale , the values of the both tables are creating Many - to -Many Relationships.

      Which means based on the values of the name column , the relationship automatically detects its a One-to-One , One-to-Many OR Many - to - One .

       

      Finalyy,

      If both table having duplicate names then it will create a Many - to - Many Relationships.

      So it wont support at the movement.