Forum Discussion
Relationships Between Rows and Colums
As a follow up to this, I have tested some different sized data sets with UIDs which are different from those in the dataset which worked yesterday and I get an error even with 20 columns so I am now wondering whether there is some specific issue within the data set.
The specific error is:
Column 'Time' in Table 'Time' contains a duplicate value '80.583' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
I have checked that all my UIDs are unique. The 'Value' column does not contain unique values but then this was also the case for the dataset which worked!
Many thanks,
Claire
It sounds to me like the two tables are being joined on the incorrect column. As the Time column should contain your measures, duplicates would be okay here. My suspicion is that Power BI is attempting a join on this column, which is not correct (and it might be due to naming conventions between both tables).
You might want to edit the relationship to confirm that it's joining on the UID columns (they should be higlighed in both tables). If not, then update the join to specify these two columns, and this should be correct.
If it's not this, then it going to be easier to help if it's possible to get a copy of your report, as it's difficult to tell what other factors might be at play.