Can we have more than one active relationship between two tables in data model of power pivot?
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 |
What is Power Pivot?
Name all the platforms for which power bi app is available?
Would we be able to invigorate our Power BI reports once transferred to a cloud?
What are the features of power bi?
Is the power bi service accessible on-premises?
What is xVelocity in-memory examination motor utilized as a part of Power Pivot?
What are some of differences in data modeling between power bi desktop and power pivot for excel?
What are the primary requirement for a table to be used in power map?
What are the basics needed for using power bi?
Define content packs?
What is a calculated column in power bi and why would you use them?
What are some of the contrasts in data displaying between Power BI Desktop and Power Pivot for Excel?