Forum Discussion
Refresh issue
Hi.
I am new to PowerBI and facing problem in my refresh data. I am using Odata feed as s source. I published my data and added all security keys etc . Data refresh on daily basis for my dashboard was working perfectly more than a week but today it doesnot refreshed I got this error. I didnot modify my data source then why this error. Trying to resolve but didnot understand . If someone can help me .Really big Thanks .
Hi SaKhan ,
It looks like you’re encountering an error related to a duplicate value in the ‘EffortVariance’ column of your ‘Plan_Project’ table. This issue can occur if a column that is part of a many-to-one relationship or a primary key contains duplicate values.
Ensure that the ‘EffortVariance’ column does not contain duplicate values in your Plan_Project table.Hi SaKhan ,
Did Bibiano_Geraldo reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.Best regards,
Adamk Kong
4 Replies
Hi SaKhan ,
It looks like you’re encountering an error related to a duplicate value in the ‘EffortVariance’ column of your ‘Plan_Project’ table. This issue can occur if a column that is part of a many-to-one relationship or a primary key contains duplicate values.
Ensure that the ‘EffortVariance’ column does not contain duplicate values in your Plan_Project table.Hi SaKhan ,
Did Bibiano_Geraldo reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.Best regards,
Adamk Kong
Remove duplicates from excel sheet
That would work 🙂
in your data model, you have table called "Plan_project" and has an one to many realtionship with other table on column "Effort Variance".
as per data model, you can not have duplicated value in column , if it has been used in one to many raltionship. so please update the relationship to many to many or remove duplicated from data
