Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models by Nisal Mihiranga

Author:Nisal Mihiranga [Mihiranga, Nisal]
Language: eng
Format: epub
Publisher: BPB Publications
Published: 2022-08-15T00:00:00+00:00

One to One (1:1): This means both sides of tables have unique fields. See the following image for the one-to-one relationship:

Figure 8.8: One to one relationship

For example, this is less often used. Imagine you have two tables that contain an equal number of rows, the same data with an ID column and having different attributes. In such a case, you need to extend one table with the second table attribute.

Many to Many (*:*): This kind of relationship has both sides with more than one unique value. See the following image for many-to-many relationship:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.