Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to Solution.
Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂
Figured this out. I needed to change it from 1 to 1 to 1 to Many 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |