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.
hello,
i have 2 tables. Table 1 = 764 rows, Table2=9384 rows.
i keep getting error messages saying " relationship cannot be created, because 1 of the columns must have unqiue values" through 1 does have have unique values...
any otpions? thanks
Solved! Go to Solution.
If there is even one of the values repeated it is not Unique.
Manually set the relkationship:
Go to the Schema View
Click on Manage Relationships
Select the table with Many data points (top section), highlight the column to link
Select the table with unique values (bottom Section), highlight the column to link
Cardinality: Many to one
Cross Filter direction: Single
If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values.
Hi @ilcaa72,
Your table with unique values must not include a blank row.
Can you check whether this is the case?
If you create a table with twice the key in the columns, once as text and once as count, you can check whether certain values appear twice or if your table includes blank rows.
Regards,
Valérie
If there is even one of the values repeated it is not Unique.
Manually set the relkationship:
Go to the Schema View
Click on Manage Relationships
Select the table with Many data points (top section), highlight the column to link
Select the table with unique values (bottom Section), highlight the column to link
Cardinality: Many to one
Cross Filter direction: Single
If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values.
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 |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |