Refresh issue

[SaKhan]

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 .

[Bibiano_Geraldo · Accepted solution]

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.

[v-kongfanf-msft · Accepted solution]

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

[Bibiano_Geraldo · Accepted solution]

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.

[shreebidwai]

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

[Khyati01]

Remove duplicates from excel sheet

That would work 🙂