Help, pls! I build a single table by appending records from different sources. Things have been running fine, until earlier this week when I noticed that I had duplicate records showing up. The OID field is the source ID. In Desktop, I have now have duplicate records. When I check in Query to see why there are duplicates, there are only single lines showing up. Why am I getting duplicates showing up in Desktop?
If I run just refresh the single query, it then clears out the duplicates, but it's frustrating to have this issue cropping up.
Hi @tuckstar ,
Based on the description, try to select file > options > clear the cache. Then, refresh the dataset.
Besides, try to remove duplicates rows in power query editor.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I do see that - apologies, I would have to see the dataset to be able to be any further help.
Tx. How can we go about doing that?
It looks like you'd have to load to a share drive and then share it.
I have run into this type of issue when I merge data from one table into another some times. Did you do any table merges or append any tables together? If so, go into your Transform Data view and filter the table by the OID to see if there are duplicates in your source - if so, work back up through your Applied Steps to determine at what step the records duplicated and then determine how to resolve it.
Thx for the response. I do some merges, but I went to the end of the query and filtered on a couple of records that were duplicated, but there were only single records. Don't know if you saw the image, but these are the current states for the Desktop table and the matching Query table, with the query filtered at the very end to only select a couple of records.
