Microsoft Power BI Cookbook
上QQ阅读APP看书,第一时间看更新

Create model relationships

  1. From the Modeling tab of the Report or Data view, select Manage Relationships and click on New.
  2. Create many-to-one, single direction relationships from each fact table to its corresponding dimension table.
    • Date data type columns should be used for the Date table relationships.
Relationships view of a multi fact data model
  • Bidirectional relationships should only be implemented with clear guidance and evaluation.