Data refresh error

[SaKhan]

I am facing and shcedule refresh error. Dashboard i created is more than 1 month every day it was working perfectly,I didnot change any thing in my data not even open the dashboard from many days 

but all of sudden today morning I am getting an  error message like below . Could you help me undertsand and resolve the issue.
Thanks.

Data source error: Column '<oii>ScheduledEffort</oii>' in Table '<oii>Plan_Enhancement</oii>' contains a duplicate value '0' 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: Plan_Enhancement.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 77fbc0d0-7aa0-40ad-a4f5-f8d6818a4c1e
Request ID: bc3aa5a6-9dc8-77c3-8ad9-c73759765e62
Time: 2025-02-05 12:07:23Z

[nilendraFabric · Accepted solution]

Hello @SaKhan 

The error message you’re encountering in Power BI indicates that the column `<oii>ScheduledEffort</oii>` in the table `<oii>Plan_Enhancement</oii>` contains duplicate values, which is not allowed for columns used as the primary key or on the “one” side of a many-to-one relationship.

Please check your source data for duplicates

Use the “Remove Duplicates” option under the Home tab to identify duplicates.

If duplicates exist but are unintended:
• Use Remove Duplicates in Power Query for the `<oii>ScheduledEffort</oii>` column.

if this is helpful please accept this solution 

[v-nmadadi-msft]

Hi @SaKhan  ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @SaKhan,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you

[Poojara_D12 · Accepted solution]

Hi @SaKhan 

The schedule refresh error in your Power BI dashboard is due to a duplicate value in the column ‘ScheduledEffort’ within the table ‘Plan_Enhancement’. This column is likely being used as a primary key or as the "one" side of a many-to-one relationship, where unique values are required. Even though your dataset was working fine for over a month, data refresh issues can arise due to changes in the underlying source data, even if you haven’t modified the report. This could be caused by new data being added, external updates, or changes in the data ingestion process. To resolve this, first, check the ‘Plan_Enhancement’ table in Power Query Editor or your source system to identify duplicate values in the ‘ScheduledEffort’ column. If duplicates exist, you may need to remove them, transform the column to ensure uniqueness, or modify relationships in Power BI. Additionally, review the data source update process to prevent such issues in future refreshes. If needed, you can also remove or modify the existing relationship in the Model view to allow duplicates.

[v-nmadadi-msft]

Hi @SaKhan,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[SaKhan]

I didnot use this table in my dashboard , Here is the Model view :

[Idrissshatila]

Hello @SaKhan ,

but there's relationships between this table and other tables, please check the columns that are linked with other tables, one of them has duplicates.

to solve the issue, if you're not using this table at all , just remove the links from it with the other sides.

[SaKhan]

My relationships looks like this . I cannot find anywhere Plan_Enhacement table. 

[anilelmastasi]

The error occurs because the ScheduledEffort column in the Plan_Enhancement table contains duplicate values, which is not allowed on the "one" side of a many-to-one relationship or as a primary key. To fix this, check if ScheduledEffort is correctly defined as a unique identifier, and if not, use a truly unique column instead. You can identify duplicates using a DAX measure or by reviewing the table in Data View. If uniqueness is required, remove duplicates or adjust the relationship to use a different column. Alternatively, if the relationship must remain, consider changing it to a many-to-many relationship, though this may impact performance.

Check_Duplicates =
VAR DuplicateCheck =
CALCULATE ( COUNT(Plan_Enhancement[ScheduledEffort]), ALLEXCEPT(Plan_Enhancement, Plan_Enhancement[ScheduledEffort]) )

RETURN
IF(DuplicateCheck > 1, "Duplicate Found", "Unique")

[nilendraFabric · Accepted solution]

Hello @SaKhan 

The error message you’re encountering in Power BI indicates that the column `<oii>ScheduledEffort</oii>` in the table `<oii>Plan_Enhancement</oii>` contains duplicate values, which is not allowed for columns used as the primary key or on the “one” side of a many-to-one relationship.

Please check your source data for duplicates

Use the “Remove Duplicates” option under the Home tab to identify duplicates.

If duplicates exist but are unintended:
• Use Remove Duplicates in Power Query for the `<oii>ScheduledEffort</oii>` column.

if this is helpful please accept this solution