Unanswered

Is the Account and Contact table in a one-to-one relationship?

(0) Share

Report

Posted on by ThePowerBro

Hi experts,

Today I imported the Account and Contact tables in Power Bi and opened the Model view. And found a 1:1 relationship between Account (parentcontactid) and Contact (Contact).

I always believed that Account and Contact are in 1:N respectively. As Contact table as lookup of Account and Account has a subgrid of contacts. But it is also true that Account table also has a Lookup column "Primary Contact" which is a lookup of Contact table. In short Account table has subgrid of Contact as well as a lookup column on Contact.

When I check the relationship in dataverse it shows 1:N relationship but in Power Bi it shows 1:1 relationship. I have also added a screenshot from Power Bi

I'd really appreciate if anyone can explain the this to me.

Categories:

Microsoft Dataverse with Power Apps

img1.png

I have the same question (0)

All responses (2)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Hi , @ThePowerBro

I test it in my side , it is one-to-many relationship in my side and I'm not sure why it's recognized as one-to-one on your side.

And you can update the relationship in your PowerBI:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
SteRe 254 on at

Like (0)

Report

That's a clear 1:N relation. To every account there can be many contacts, but every contact is assigned to 1 account only (Dynamics Standard).

Was this reply helpful? Yes No