Forum Discussion
Table Updating issue
Hello,
I run a scheduled update for my data from a file that has 8 tabs creating 8 tables from a sharepoint drive. the Source.name file in all is the same vale (the source file) but in one table it is not updating and saying that the data is duplicate. I am at a loss on how to correct this. Here is the error message I keep getting. I believe it has to do witht he way the data model set up when I did the initial import of data.
Data source error: Column 'Source.Name' in Table 'Edgerton' contains a duplicate value 'Data for Roll Out.xlsx' 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. Table: Edgerton.
Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: e0d07a2b-28ad-43e5-bfb7-17cb201fd94f
Request ID: 36b389d4-2b78-b5eb-c783-2c0fed6fc0a0
Time: 2024-05-13 15:39:48Z
Any help is appreciated, Thanks Ron
In your 'Edgerton' table you are using a column as the one side of a one to many relationship. The error is telling you that there are duplicate values in that column, or there are blanks in that column.
One path forward is to identify the column in question and add a remove duplicates step to the query. If blanks are your issue you can filter them out prior to updating the model as well.
Of course the best practice would be to analyize your table to understand why there are duplicate or blank values and correct the problem at the source.
Hope this helps.
1 Reply
In your 'Edgerton' table you are using a column as the one side of a one to many relationship. The error is telling you that there are duplicate values in that column, or there are blanks in that column.
One path forward is to identify the column in question and add a remove duplicates step to the query. If blanks are your issue you can filter them out prior to updating the model as well.
Of course the best practice would be to analyize your table to understand why there are duplicate or blank values and correct the problem at the source.
Hope this helps.