Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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:
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.
please show a picture of your data model, highlighting the relationship fields
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |