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,
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
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |