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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Additional rows appears in Table View after Append in Power BI Dekstop

Hello, 

 

I have pulled data from salesforce and then from sharepoint and appended it in to one table. I cannot understand what went wrong, but in Power Query I do not see any duplicates, however when I open same table in Table View i can see duplicate rows but with different values:

Agne_J_2-1693499514593.png

 

 

Agne_J_1-1693499411106.png

 

 

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

@Anonymous Remember that Power Query only shows the first 1,000 rows so it's possible the duplicates are not within the Preview of the data?



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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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.

Top Solution Authors