topic Re: Duplicate data - why and how to remove? in Report Server

Duplicate data - why and how to remove?

vasildimitrov — Tue, 11 Jul 2017 11:36:57 GMT

Hi, I have very frustrating issue. A report for bugs opened @today -1 is showing duplicate values, that very strangely are listed a couple of times and then at the end of the table I see all the extra repeated values subsctracted. Why is this happening and how to get rid of these repeated records?

I've tried everything I could think of, thanks in advance to whom knows the answer!

Re: Duplicate data - why and how to remove?

Greg_Deckler — Tue, 11 Jul 2017 12:50:32 GMT

What source is your data coming from?

Re: Duplicate data - why and how to remove?

v-yulgu-msft — Wed, 12 Jul 2017 02:47:00 GMT

Hi vasildimitrov,

What is your data source? If possible, share the sample data so that I can test in my environment. Were these duplicated rows existing in table view after loading data into desktop? What is the desktop version you are using?

By the way, as this is the forum is specific to Power BI Report Server On-Prem and not Power BI.com, if you have any trouble with report design or Power BI service, please post your question on Desktop or Service.

Regards,
Yuliana Gu