Forum Discussion

skaranth10's avatar
skaranth10
Helper I
5 years ago

Duplicate rows on Table Visual

Hi, I am facing a small problem here in trying to compile a report. It seems quite simple, but I am just not able to get the desired result.   I have two tables - OrserUserFields & Orders, which a...
Need Help
skaranth10's avatar
skaranth10
Helper I
5 years ago

Hi Anonymous , Regarding the duplicates, the OrderUserFields table has multiple rows with the same OrderId, but deffierent value for each of the columns - #pku, #frozen, etc. 

I haven't touched anything on the Query Editor.  The only thing I have done to the data source is that I have pivoted the PrimaryLabel column on Values (Non-aggregated).  

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi skaranth10 ,

 

Try use the orderid in orders table.

Without a sample pbix may not know the exact issue.See if you could share the sample pbix via cloud service like onedrive for business.

Please remove any sensitive data before uploading

 

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

  • skaranth10's avatar
    skaranth10
    Helper I
    5 years ago

    Hi V-lianl-msft ,

    I did use the OrderID from the Orders table. It still creates the duplicates for # of Ambient, # of frozen, # of Pkus, etc that I pull into the visual. A duplicate is created for each one of them on the table. 

     

    I will work on hiding sensitive info and share the pbix file here in a bit. 

     

    Thank you! 

     

    Regards,

    Sanjay

  • skaranth10's avatar
    skaranth10
    Helper I
    5 years ago

    Hi V-lianl-msft ,

    I have the pbix file ready, but am not sure how I can attach it here. Any way I share it here?

    I am not sure how I can share it through Onedrive for business either. 

     

    Regards,

    Sanjay