Forum Discussion
Power Pivot Relationship Questions
I have a file that is coming from SharePoint with a Multiple Selection field, this translates in excel to: Macro;#Process for Web;#Auto-fail I'm adding this table to Power Query and the...
So the relationship between Table2 and Reason Breakdown would technically be 1-to-1, if that type of relationship were supported in Power Pivot?
If so, you simply need to amend the relationship such that the Reason Breakdown table is on the 'one' side. When presented with a 1-to-1 relationship, which is not supported in Power Pivot, it will designate it as a 1-to-many relationship. However, the side which is assigned as '1' is dependent upon the order in which you choose the tables when creating the relationship, and can easily be reversed.