Forum Discussion
Refresh Error - Duplicate Vale & Many to One
Sometimes Power BI seems getting crazy on relations because of metadata cache. Simply rename the column in Report view and try again, if it resolves you can correct the column name again.
Renaming the Column did not work. However, I did create a duplicate of the "Extended" Column, then deleted the orginal column, moved the copy and renamed it back to "Extended". This fixed the issue, at least for now. Why I do not know.
I'm still confused on the orginal error as it stated that the my "Extended" column was on the oneside on the Many to one relationship. This column is on the Many side.
FormworkFan
it has to be with how you are building your model.
If you want to use a Sales table as a dimension table in a "one-to-many" relationship you need one field with unique values to be used as the key of the ONE side of the relationship, otherwise you have a many-to-many relationship.
For the OneSide Table: You don´t need to have a table with "distinct registers"but you need one field with distinct values to used as the key of the relationship ensuring the distinct values of your ONE side of your relation ship.
As you have told, it seams to be that your sales table is a Transactional (Not dimensional) Table.
I hope this helps.
If this response was helpful in any way,
I’d gladly accept a kudo.
Please mark it as the correct solution.
It helps other community members find their way faster.
Thanks for the Reply.
I don't think I'm trying to use my Sales Table as a Dim Table. Below you can see how I have my model set up.
I have 5 Dim Tables (with unique values - One ) coming back to my Sales Table (Many).
All of these relationships are Many to one with the cross-filter direction set to single.
I'm not sure how I can have a column in my sales table that will always have a unique value, unless I can create a column with a row counter or something like this.
The "Extended" or Sales column in my transactional tables are listed as my sort columns by default. I can only assume this was set alphabetically.
FormworkFan Please confirm which table in this model is the one associated with the Table "2026 PBI Curing" that is reported in the warning error. Please confirm if there is any table in this model with a field called "Extended" in the ONE side of the relationships.
FormworkFan Please check if the "Extended" column is set as a primary key.
In Power BI Desktop:
1. Switch to Model View
2. In the TablePane Select the Table with the Issue (not the column "Extended")3. In the Propeties of that Table check if it has a Column selected as a KeyColumn
If there is a column selected as a KeyColumn please adjust as needed.
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster.I have 15 Seperate Sales Force Reports, of that "2026 PBI Curing" is one of these. I also have an excel file that is being pulled in, so a total of 16 simular data sources that have the details on sales transactions. I have appended these reports in to a new table "All Divisions Table RS". This is the table you can see on my model veiw.
I did look at the model veiw and the "Extended" column is not listed as the Key Column. This is empty. No column in the reprot is list as the Key column in this these tables
FormworkFan In your 1st post you told that The "Extended" or Sales column in my transactional tables are listed as my sort columns by default.
Could you please give some more info about this statement?
Is your "Extended" field marked as the sort column for other field in the "All Divisions Table RS" table? if so, there should be just one register in the "extended" column for each different register in the column that it helps sorting. If you have more than one register please try changing the column that sorts (you can create a new column with alfanumeric or added numbers to have different values for each time there is an Extended register that has more than one register in the Column to be sorted by the ExtendedColumn.