Does it matter which table you start on when creating a relationship? (Facts vs Dimensional)

[v-shex-msft · Accepted solution]

Hi @brs09j,

About create relationships, power bi will auto modify the direction of relationship(from unique side to multiple side).

In addition, if both of tables not contains the unique value, you can't direct create the relationship between them, you should add an unique table to link these tables.

Regards,

Xiaoxin Sheng

[FreonYz]

Hello Xiaoxin,

@v-shex-msft 

The problem is that, even I am sure there is one column contain unique values in one of my two tables, it still warns me "You cannot create a relationship between these two colunms because one of the comumns must have unique values".

The table containg the colunmn which has unique values is from my local spreadsheet. I have tested in quite a few ways and made sure there is not duplicated records. But still, Power BI does not allow me create relationships in my case.

Thanks!

[KHorseman]

Not that I have ever noticed. Whether you go from the 1 side to the N side or the N to the 1 it's still a 1:N relationship either way.