Forum Discussion
Dupilcation error
- Data source errorColumn '<pii>department_id</pii>' in Table '<pii>cmkpebook1 board_meetings</pii>' contains a duplicate value '<pii>69</pii>' 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.
Hi All,
Need your kind help on how can I remove the above error in a published report.
Thanks
Engr. S
Hi AliShahab88 ,
Did you use incremental refresh? you have full data load and that's when there is a duplicate /blank value and causing the issue in the service and not in the desktop since in desktop you are seeing partial data.
Are there any blank values in your column? You can check whether the column is allowed to be null in SQL.
Get “not allowed for columns on the one side of a many-to-one relationship” errors
You need to check the relationship between the tables in the Desktop Model view. Power BI will automatically create relationships for similar columns.
You may refer to Solved: Duplicate Value - Microsoft Power BI Community.
- delete the row in the database as a workaround
Or The '<pii>ColumnName</pii>' column does not exist in the rowset.
- Personaly would unpivot "other columns" and rebuild data model around that.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Looks like either a design problem or a data problem (I can't say which, you will have to investigate). The design says there is a 1-many relationship or a primary key defined. That was probably working fine at first. Then a data refresh occurs that violates the design by having 2 records with the same primary key. So, either the design is wrong or some data has been wrongly entered into the system.
Thank you HotChilli for stunning help 🙂.
Thanks HotChilli, but I want to change in publish data source I mean to change the relationship and data type etc.
Hi AliShahab88 ,
Did you use incremental refresh? you have full data load and that's when there is a duplicate /blank value and causing the issue in the service and not in the desktop since in desktop you are seeing partial data.
Are there any blank values in your column? You can check whether the column is allowed to be null in SQL.
Get “not allowed for columns on the one side of a many-to-one relationship” errors
You need to check the relationship between the tables in the Desktop Model view. Power BI will automatically create relationships for similar columns.
You may refer to Solved: Duplicate Value - Microsoft Power BI Community.
- delete the row in the database as a workaround
Or The '<pii>ColumnName</pii>' column does not exist in the rowset.
- Personaly would unpivot "other columns" and rebuild data model around that.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
