Forum Discussion

Icon for Helper I rank

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...

Anonymous

Not applicable

5 years ago

Is it showing the duplicate values in Data Model as well?

And did you removed duplicate rows in Power Query if not required ?

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
  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
    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