I'm having a difficult time creating a relationship between two excel tables.
I created a column type at both table indcating if a task is a pilot, rollout, product or customer.
When I am traing to make a relation bettween the two I am getting an error meesage that "mast have a unique value"
Any sugesstion how to create this relationship?
Go to Solution.
1 of the table columns must contain only unique values.
If your tables both have repeating values for valid purposes - you must create a new table with distinct values.
You then connect the 2 tables you have to this 1 distinct table rather than attempt to join them both together directly.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.