Forum Discussion
Dataverse One to Many Relationship
I have two dataverse tables "Contacts" and "Attendance". The Attendance has 1:N relationship to Contacts. When I pull these tables into Power BI, I'm not able to get the 1:N relationship table to pull in with them from Dataverse. Does anybody know how that data out of dataverse into Power BI?
4 Replies
Hi jtbucy - In Power BI, you can connect the dataverse (Home > Get Data > Dataverse) and import the tables in Power BI Desktop. Once you load the two tables into power bi , go to the Model view.Ensure that the relationship between "Contacts" and "Attendance" is correctly established. The relationship should be 1(one-to-many) from "Contacts" to "Attendance".If the relationship is not automatically detected, you can create it manually by identifying the common columns like eg: contact table --> ContactId to Attendance table "ContactId columns with relationship is set to "Many to One (*:1)" with the correct cardinality.
How to Get Data from Dataverse Tables into Power BI Desktop (youtube.com)
Contact table/entity reference (Microsoft Dataverse) - Power Apps | Microsoft Learn
Hope this information helps. if any please share snapshots and reference .
Thanks for the reply. However, that is not what I'm trying to do. I have a Model Driven that adds Contacts to the Attendance table by association. Dataverse store this in a separate relationship table that Power BI cannot pull in. I need to the report to display the list of contacts that get associated to each attendance:
Hey,
No, my issue is not resolved. However, I made a new relationship of Many : Many and was able to pull in the associated contact records from the attendance table.
