Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more

Reply
Rafaelpalma
Frequent Visitor

Add query repeating records

‎10-28-2021 10:17 AM

Good evening!
I have a report where I use the function "add new queries" (I join tables/base that have the same columns and headers). I noticed that the append is duplicating the table records. For example, the total should be 700 records (adding all tables/bases that contemplate the scope), however, 4000 records are appearing. I went to analyze and saw that they had the same duplicate records.
Does anyone know why this happened? and how do I fix?

Labels:
Message 1 of 2
835 Views
0
1 REPLY 1
KNP
Super User
Super User

‎10-28-2021 05:56 PM

Hi @Rafaelpalma, 

 

Can you share your Power Query code (remove any sensitive info)?

It will make it easier for us to figure out what is going on.

 

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 ;).		xOIEmaj

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.
image		fabric-SUbadge
Proud to be a Super User!
Message 2 of 2
757 Views
0

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All