Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relationship problem primary key

Hi all, 

 

I have a problem trying to relate two tables

 

Table 1:

 

Workbook name (unique values)

Resource 1

Resource 2

Resource 3

Resource 4 

 

Table 2

 

Activity        Workbook Name 

Activity 1     Resource 1

Activity 2     Resource 1

Activity 2     Resource 2

Activity 2     Resource 3 

 

 

I want to relate the table 2 with the table 1 but I can not find the way to create a primary key composed by two columns and that could be related with resources. 

 

Any idea? any help?

 

Thank you in advance!!

 

  • Hi Anonymous ,
    These will relate automatically in Power BI.

     

     


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion

    Hi Anonymous ,
    These will relate automatically in Power BI.

     

     


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

  • not sure I got. But when u have workbook name at both place why do need something else to connect