Duplicate error when refresh/load

[nuhasan]

Hi all,

Im facing below error since yesterday. Can someone help to explain to me the best way to solve this.

Solution I already done & I refresh back the data but still facing the same error.

1. Change one to one relationship to many to many.

2. Change one to one relationship to one to many

3. Change one to one relationship to many to one.

4. Delete the relationship.

Regards,

Nuha

[v-stephen-msft]

Hi @nuhasan ,

Judging from your screenshot, your error is not only the relationship error.

Deleting the relationship can solve your first error message.

After deleting the relationship, refresh the report, may I ask what other errors are displayed?

Best Regards,

Stephen Tao

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

[jennratten]

Is it correct that SAP_PPT_MaterialDocument_TotalGR should load duplicate values to the data model?  If not, an easy solution would be to filter out the duplicates in Power Query and then load to the data model.

[nuhasan]

yes. it should load duplicate values to the data model