Dynamics 365 online. relationship between contact and marketing list

[Anonymous]

Dynamics 365 online. default entities "Contact" and "Marketing list"

I need to create relationship between these tables.

Which fields do I need to use for relationship?

[v-juanli-msft]

Hi @Anonymous 

I don't know which Dynamics 365 app you connect to, so i can't reproduce this scenario so far.

For creating relationships, Power BI has an inbuilt facility available to create the relationship on best possible matches.

For using this, click on the "Manage Relationship"option, a window will appear,click on "Autodetect"

A message will appear which is the best available match for the relationship by Power BI between both the tables.

Reference how to create proper relationship:

https://www.c-sharpcorner.com/article/creating-and-managing-relationships-in-power-bi/

https://radacad.com/many-to-one-or-many-to-many-the-cardinality-of-power-bi-relationship-demystified

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.