Can we have more than one active relationship between two tables in data model of power pivot?
- 1 Answers
- 84 Views
- I also Faced
- E-Mail Answers
Answer / Ajay Pratap Singh Yadav
Yes, it is possible to establish multiple active relationships between two tables in the Power Pivot data model. However, each table can only have one direct relationship with any other table. If there are multiple relationships involved, these relationships should be indirect, i.e., go through another common table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is Power BI accessible on-premises?
Would we be able to invigorate our Power BI reports once transferred to a cloud?
What data sources can power bi connect to?
What is Power View?
What are the data destinations for power queries?
Can sql and power query/query editor be used together?
For what reason do we require Power Query when Power Pivot can import data from for the most part utilized sources?
What are the benefits of using variables in dax?
Would we be able to have in excess of one dynamic connection between two tables in the data model of intensity rotate?
Is it possible to have over one active relationship between two tables in power pivot data model?
What is the Power BI Publisher for Excel?
What are some common power query/editor transforms?
QlikView 
