Forum Discussion

SaKhan's avatar
SaKhan
Frequent Visitor
1 year ago
Solved

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 ...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    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.

     

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    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

shreebidwai's avatar
shreebidwai
Frequent Visitor
1 year ago

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