Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.