Duplicate data - why and how to remove?

[vasildimitrov]

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!

[v-yulgu-msft]

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

[Greg_Deckler]

What source is your data coming from?