Solved: Some records duplicating

Anonymous · ‎10-19-2021

Hi I am relatively new to Power BI, I did a refresh on my data to update my visuals and the most recent records have seemed to duplicate for some reason.. I have not changed anything since the last refresh and if it were something i done surely it would apply that duplicate to all records.. There are no duplicates in power bi query editor or the excel which is pulling the data via an API.. Strangely the values are in query editor and don't display but then when i sort the values by ascending this is what triggers them to display in the visualisation and duplicate... i have merged tables but again did this a while ago and if this were the cause im sure all records would duplicate.

KNP · ‎10-19-2021

Can you paste the query from PowerQuery?

Change any detail that is sensitive. See gif below if you need help with this.

This will give us a chance to point out possible causes.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!