Forum Discussion

lfil's avatar
lfil
Regular Visitor
5 years ago
Solved

Relationship_matching table

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

Need Help
  • lfil's avatar
    lfil
    5 years ago

    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

4 Replies

  • lfil's avatar
    lfil
    Regular Visitor
    5 years ago

    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's avatar
      v-yingjl
      Community Support
      5 years ago

      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

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    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.