Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tuckstar
Frequent Visitor

Duplicate records appearing in desktop

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.

 

tuckstar_0-1723750989518.png

 

6 REPLIES 6
Anonymous
Not applicable

Hi @tuckstar ,

Based on the description, try to select file > options > clear the cache. Then, refresh the dataset.

vjiewumsft_0-1724059309900.png

Besides, try to remove duplicates rows in power query editor.

vjiewumsft_1-1724059322009.png

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.

DataIsMyMN
Frequent Visitor

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. 

Reference: https://community.fabric.microsoft.com/t5/Desktop/Best-way-to-share-a-power-bi-report-in-this-forum-...

DataIsMyMN
Frequent Visitor

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.

tuckstar_0-1723752127580.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.