Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I am appending several queries eg:
query A
query B
query C
I want to create a custom column in the append result query that will display the source query name the record was from eg:
Append results:
fruit qty source query
apple 23 query A
pear 4 query A
orange 33 query B
grapefruit 4 query B
....and so on
Solved! Go to Solution.
You may change code in The Advanced Editor.
Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "source query", each "query B") , Table.AddColumn(#"query C", "source query", each "query C")})
Thank you, the problem was soluted
There is a workaround using #sections now!
This is nice but, what if I have like 100 tables I need to append? How can we make this code dynamic so that it gets the table name for each row?
You may change code in The Advanced Editor.
Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A") , Table.AddColumn(#"query B", "source query", each "query B") , Table.AddColumn(#"query C", "source query", each "query C")})
Not pretty, but it worked, thank you.
This really should be a built-in function, it would make the append query much more useful.
Thanks a lot for this. It came in very handy. I needed to combine 72 Tables for cleaning. It worked well.
Wonderful solution, thank you! Came in very handy in my work today.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |