Is it possible to have over one active relationship between two tables in power pivot data model?
Answer / Amardeep Karn
Yes, it is possible to have multiple active relationships (also known as many-to-many relationships) between two tables in Power Pivot Data Model. However, these relationships should be properly designed using junction or intermediate tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain various parts of microsoft self-service bi solution?
What is the common table function for grouping data?
How is data security executed in Power BI?
What are the data destinations for power queries?
What are the data administration portal and Power BI individual door?
What is Power BI Q&A?
Define excel bi toolkit?
How one can get started with power bi?
What are a few advantages of utilizing variables in DAX?
What are the different types of refreshing data for our published reports?
What is question collapsing in Power Query?
Why do we need power query when power pivot can import data from mostly used sources?