The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I'm trying to link two tables based on a location number. In the first table (sales) there are duplicate location numbers, and in the second table (locations) the location numbers are unique. However when I try to link the 2 tables I get the following error message:
Please can you help?
Thanks,
CM
Solved! Go to Solution.
Hi - it's fixed. The left hand table's field was a number stored as text and the right hand table's field was a number stored as a number. So (in excel) I converted the right hand side table's field to number stored as text and the link now works. But I think the error message I got was incorrect as there were no duplicates (I checked using countif in excel).
How do you know the second table location numbers are unique? This error message would indicate otherwise...
Hi - it's fixed. The left hand table's field was a number stored as text and the right hand table's field was a number stored as a number. So (in excel) I converted the right hand side table's field to number stored as text and the link now works. But I think the error message I got was incorrect as there were no duplicates (I checked using countif in excel).
Hi @CloudMonkey,
Great to hear the problem got resolved! Could you accept your helpful reply as solution to help others who may also have the similar issue easily find the answer and close this thread?
Regards
User | Count |
---|---|
58 | |
54 | |
53 | |
49 | |
30 |
User | Count |
---|---|
177 | |
88 | |
70 | |
48 | |
48 |