Forum Discussion

ashutosh's avatar
ashutosh
Helper I
9 years ago

Duplicate values in Report

                                                          Why I am getting duplicates rows in my report ?
Need Help
Show and Tell
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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's avatar
ashutosh
Helper I
9 years ago

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's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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