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

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? This is a Model Driven App that generated the IDs and primary keys for me. I assume there is a PersonVolunteers.PersonID that it needs to join on the Persons.PersonID, but the PersonVolunteers.PersonID is not an option in Power BI.

1 ACCEPTED SOLUTION
quarterpress
Frequent Visitor

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

View solution in original post

1 REPLY 1
quarterpress
Frequent Visitor

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors