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 am getting the error "You can't create a relationship between these two columns because one of the columns must have unique values." Previously to get around this I would create a new table that would act as they Key and form a relationship to/from the key. This time I am still getting the error, I have read multiple form posts regarding this issue but none of the solutions have helped.
I recently added a table to my report and wanted to create a relationship with an existing table. The original table "Value Entry" is a table that has all entries in our Nav ERP system and the new table is "Sales Rebate Ledger Entry" which lists all of our sales rebates. I would like to create a relationship from the document number, but I have been unable to do so.
I have tried to create a Document Number Key and I made sure there was no blank/null cells but I still cannot create a relationship. The Value Entry table has all documents and the Sales Rebate Ledger Entry only has the documents with an applied rebate.
Any out of the box ideas? I am not sure why this is not working, any and all help is greatly appreciated. I have been working on this on/off for a week or so with no good results.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |