Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |