Managing Relationship - data Not coming through

[Nailer]

I have two seperate excell spreadsheets, both have the same reference number.

When I manage the relationship between these two files, the second coulmn does not populate correctly and comes up as a random number. 

This is the relationship i have set up as the cardiality will not let me change it from many to many. 

I have tried also linking bot to a go between to see if that helps but it does not 

Do i need to change something in the raw data for this r

[v-mdharahman]

Hi @Nailer,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-mdharahman]

Hi @Nailer,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Best Regrads,

Hammad.

[v-mdharahman]

Hi @Nailer,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.

Thank you.

[v-mdharahman]

Hi @Nailer,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[v-mdharahman]

Hi @Nailer,

Thanks for reaching out to the Microsoft fabric community forum.

Can you please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

I would also take a moment to thank @PwerQueryKees, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[PwerQueryKees]

In at least 1 of your files the reference number should be unique.

You probably can't fix it at the source, but maybe you can use powerquery to transform the data to satisfy this requirement.