Duplicate data - why and how to remove?

vasildimitrov · ‎07-11-2017

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 · ‎07-11-2017

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎07-11-2017

What source is your data coming from?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...