Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multiple IDs in a relationship

Hello,   I have a lot of data in Excel (as source files) and need to create some relationships between the two, however it's not that straight forward;   Table 1 List of roles 1 role to many n...
Need Help
  • danextian's avatar
    danextian
    4 years ago

    Hi Anonymous ,

     

    A relationship in Power BI is between the as-is values in a column in one table and those in another column in another table. If you want to have a relationship between {1,2,3,4} in another table, each of these values must be in a row.

     

    It would be easier for us to visualize what you're trying to achieve if you posted a sample data and then explain further from there.

danextian's avatar
danextian
Super User
4 years ago

Hi Anonymous ,

 

A relationship in Power BI is between the as-is values in a column in one table and those in another column in another table. If you want to have a relationship between {1,2,3,4} in another table, each of these values must be in a row.

 

It would be easier for us to visualize what you're trying to achieve if you posted a sample data and then explain further from there.