SSAS Tabular Design Model-foreign key

In tabular design models, similar to multidimensional design models,

The dimension table and the fact table are independent from each other, and are connected by the foreign keys in the relational database, which make up a unified architecture.

The DB foreign key is required to be unique, that is, when a table has a primary key or a unique key, the B table can be referenced as a foreign key.

Multidimensional design Model--star-shaped structure

Star schema is based on the fact table, the other dimension table is star-shaped distribution around the core table, the dimension table has no connection with each other, the primary key in each dimension table can only be single-column, and the primary key is placed in the fact table, as the fact table and the dimension table connection foreign key.

Tabular Design Model--

When you create a relationship, you are prompted that you cannot create a relationship because each column contains duplicate values. Please select at least one column that contains only the only merit.

DB Check:

SSAS Tabular Design Model-foreign key