Forum Discussion

quarterpress's avatar
quarterpress
Frequent Visitor
3 years ago
Solved

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.

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

1 Reply

  • quarterpress's avatar
    quarterpress
    Frequent Visitor

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