cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Power BI Dataverse Relationships

I have a "Persons" table and a "PersonVolunteers" table in Power Apps Dataverse. The Person Volunteer table has a lookup field for the Person. Power BI joins the two tables on Persons.PersonID and PersonVolunteers.Person with a 1 to 1 relationship. The PersonID field is their automatically generated ID.  The Person field is a text field (from the lookup table.) When I use a table visualization, it lists all the Persons and all the Person Volunteers. I need only the Persons where the Person Volunteer matches. So there may be 100 Persons and only 5 volunteers. I need to only show 5 rows. How do I accomplish this in Power BI?

1 ACCEPTED SOLUTION

Accepted Solutions
Syndicate_Admin
Administrator
Administrator

Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,345)