cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DanJames_DCG Frequent Visitor
Frequent Visitor

Unable to create multiple relationships to one field

Hi there. I'm very new to Power BI and hope someone can help me with what I'm sure is a basic problem, but one I can't figure out. I am working with five Sharepoint lists: UserInfo, Projects, StatusReports, Issues and Risks (I'm creating a very simple risk/issue/report app).

 

The UserInfo table has all the User Info pulled from the Sharepoint user list with a unique ID field. Each of the other tables has one at least two user fields (author and modified, for example, as well as some others like Project Manager). I'm therefore trying to create multiple relationships to the ID field in user info from each of the user fields in the other tables. If I try to create two links frmo the same table (e.g. AuthorID to UserInfo.ID and ModifiedID to UserInfo.ID), I get an error telling me to turn off bidirectional cross-filtering (it's set to single for all relationships already). If I try to create relationships from two tables (e.g. from Risks.CreatedID to UserInfo.ID and Issues.CreatedID to UserInfo.ID), I get an error saying it would introduce ambiguity between the tables.

 

Is there any way to do what I'm seeking? I want to be able to display the project manager's name rather than ID, as well as all the other user fields. Any help greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
mwegener Member
Member

Re: Unable to create multiple relationships to one field

Yes, but you could multiply via DAX Table

DAX Table:
UserInfo2 = UserInfo
4 REPLIES 4
mwegener Member
Member

Re: Unable to create multiple relationships to one field

Hi,
you have to load the UserInfo for each Role (Creator, Author, Project Manager, ...)
DanJames_DCG Frequent Visitor
Frequent Visitor

Re: Unable to create multiple relationships to one field

So, basically add a new data source for each user field? Effectively ending up with UserInfo1, UserInfo2, etc. and then define a relationship to each one separately?

mwegener Member
Member

Re: Unable to create multiple relationships to one field

Yes, but you could multiply via DAX Table

DAX Table:
UserInfo2 = UserInfo
DanJames_DCG Frequent Visitor
Frequent Visitor

Re: Unable to create multiple relationships to one field

That's great, thanks!