Forum Discussion
Append query duplicating Current Table?
When using Append query in new 64-bit version for three or more tables the current table is being duplicated and there's no remove button.
is Anyone having this problem?
4 Replies
I haven't seen it. However I assume you can remove the duplicate in the Power Query Language (PQL). Given there are multiple arguments, you should be easily able to work out the syntax and just remove the duplicate.
JuliaYebra When you say being duplicated where? in the Data Model or the Query Editor?
Do you disable loading into the Data Model of ALL except the one containing the Appended Queries?
After I have all my queries that will be appended ready (uncheck Enable Load on ALL)
I create a Blank one where I Append ALL and then Load only that one into the Model
Thank you!
I could do it!
When creacting a new Query that will be appended this is the first thing I do - even before editing - so not to forget
(beause Loading to the Data Model is the default behavior)
Uncheck Enable Load before you hit Close & Apply
