topic Re: removal of duplicate records in report builder in Report Server

removal of duplicate records in report builder

murali5431 — Mon, 19 Apr 2021 12:01:00 GMT

Hi,

I have a dataset as below, where a Pkg ID could duplicate over two invoice numbers.

When I pull a report for Pkg Ids with their dimensions (invoice number excluded), I just need to get unique rows of Pkg ID. Currently the packging IDs are duplicating. Please let me know how I can avoid duplication.

Invoice	Pkg Id	Length	Width	Height
A12	124	3	3	3
B12	124	3	3	3
A12	238	51	72	34
B12	239	51	72	34
B12	240	51	72	34
A12	118	59	41	23
B12	118	59	41	23
B12	121	102	204	13
A12	125	26	112	21

Thanks,

Muralidhar

Re: removal of duplicate records in report builder

Icey — Wed, 21 Apr 2021 02:57:21 GMT

Hi murali5431 ,

When you create table visual in Power BI Report Builder and don't use "Invoice" column, the Pkg Id won't be duplicated.

Best Regards,

Icey

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

Re: removal of duplicate records in report builder

murali5431 — Wed, 21 Apr 2021 07:18:16 GMT

Icey Thanks a lot for the response!