Merge doesn't work but relationship works

[donodackal]

Hello

I have 1000+ rows of data in table A and wanted to merge table B to it; however, the merged column is empty (no data when I try to filter it). However, if I create a relationship between tables A and B, it works which means the common key between the two tables exists and can work. So why is it when I try to merge, it doesn't work?

[v-jingzhang]

Hi @donodackal 

Which Join Kind do you select? Do you see the number of rows matched at bottom in Merge window? Does it show 0 or other values?

Is it possible to provide some sample data or sample pbix which can reproduce this problem? How to provide sample data in the Power BI Forum

Best Regards,
Community Support Team _ Jing

[donodackal]

The common fields are Australian Business Numbers...

[mahoneypat]

I suspect it is a difference in case.  M is case sensitive but DAX/relationships are not. Try making your columns the same UPPER or lower case prior to the merge.

Pat