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

3 Replies

  • 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