Duplicate values in Report

[ashutosh]

Why I am getting duplicates rows in my report ?

[v-yulgu-msft]

Hi @ashutosh,

Were these duplicate rows existing in source table? In Query Editor mode, please remove duplicates first to check whether it works.

If after removing duplicates, duplicate values still exist, this problem might be related to your data source. Maybe there are some issues with non-printable characters. You can try to trim & clean before the remove-duplicates-step. 

Regards,
Yuliana Gu

[ashutosh]

Hi @v-yulgu-msft Yuliana, 

No I don't have duplicate values in my source table. I have connected an excel file with another table with Many to One relationship and this strange duplicate happens.

[v-yulgu-msft]

Hi @ashutosh,

I noticed that the duplicate rows exist in visualization, does this behavior exist in Data view?

You said "connected an excel file with another table with Many to One relationship and this strange duplicate happens", so, if removing the relationship, the duplicate rows disappear, right? If possible, share us the sample data so that we can test in our environment.

Regards,
Yuliana Gu