Forum Discussion
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_CCommunity 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 - amitchandakSuper User
not sure I got. But when u have workbook name at both place why do need something else to connect