Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Related, Relatedtable, Lookupvale

Hello,   i got a short question: i was trying to build up a relationship between 2 sheets. Since it doesn't work automatically i thought about building a relation via lookup() formula or related()...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Anonymous,

>> since it doesn't make a relation.

Could you please share the error message for further analysis?

In order to create a relationship in a data model in Power BI, at least one side of the relationship must be tied to a column that is unique in the table. Please verify a column in one side is unique. There is no many to many relation in Power BI model.

In the Power BI data model, you can create relationship by clicking “Manage Relationship” , you will get the following screenshot. Or you can create the relationship in Diagram view as the KHorseman’s posted, you just use the Drag to Zoom control, and select a column and drag to the another column that you want to prefer in another table. More details about creating relationship, please review this article.

 


If you have any question, please feel free to ask.


Best Regards,
Angelia