"Duplicate Value" Error

[JRyan]

Hi,

I have a report that I have created in Power BI Desktop and it runs fine there, and refreshes the data fine also.

When I publish the report to Power BI Service it then works fine, but when trying to refresh the data (manually or Scheduled), I get an error about a duplicate value:

Column 'Contract ID' in Table 'Contract Line' contains a duplicate value '4835' 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: Contract Line.

To check this i refresh at the same time in Desktop and there are no duplicate values there or errors!?

Can anyone help?

[V-lianl-msft]

Hi @JRyan ,

After my test, desktop will display the same error.

What kind of connection are you using?

Based on this error, you can modify the relationship in desktop and republish this report.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.