Relationship_matching table

[lfil]

hi there, 

i have a problem with relationship between matching table (unique IDs) and table from marketing platform. There is relationship 1:n (this relationship is "working"). for example there is ID 123456 in matching table and the same ID in marketing table 123456 but there is not relationship, its not connected... another ID, the same relationship 234567 in matching table and 23456 in marketing is connected.

Really dont understand..

Can you, please, help me what is wrong there?

Thank you so much, Lucy

[lfil · Accepted solution]

Hi, 

omg, there was a space in front of the ID and my taxonomy  - split the culomn with every "_" (abc_ 123456) was confused...

Thank you for your time, Lucy

[v-yingjl]

Hi @lfil ,

So has it been solved by yourself? If so, glad to hear that. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Community Support Team _ Yingjie Li

[v-yingjl]

Hi @lfil ,

Which field you are using to create the relationship between two tables? The ID field or any other fields? Could you please consider sharing the relation view in the report with fields in details for further discussion?

In addition, you can also refer these docuements about relationships to check:

1. Model relationships in Power BI Desktop 
2. Create and manage relationships in Power BI Desktop 

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

[lbendlin]

please show a picture of your data model, highlighting the relationship fields