Forum Discussion
Merge doesn't work but relationship works
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?
3 Replies
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
The common fields are Australian Business Numbers...
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
