Forum Discussion
Will Power Pivot be enough?
Hello everyone, I am about to build a data-model, but I am unsure whether I will be able to build it in Excel (Power Pivot) since the filtering direction can only be set to one direction. In cont...
Data model is an object can be used for Power Pivot as well BI,,, what yo are trying to support it please edit your post & share some sample data along with expected output, will help us to fix it !!
Hi Rajesh!
As of now, I do not have an example, it is more of a general question. I am just wondering if the uni-directional relationships will become a problem since you cannot set the relationship to bi-directional in Excel 🙂
As of now, I do not have an example, it is more of a general question. I am just wondering if the uni-directional relationships will become a problem since you cannot set the relationship to bi-directional in Excel 🙂
Let me say something about the basic of relationship between Tables.
- One to One:
- One to Many:
- Many to Many:
1. When both parent & child table has one common column setting the relationship. and no duplicate records, like ID in both tables, has Unique records.
2. When parent table has unique records ( like unique IDs) but child table has duplicate.
3. Many to Many works when both tables has duplicates for the Field ( IDs )setting relation between tables.
Using Data model,,, data diagram you can set relationship between tables.