Forum Discussion
Q630
3 years agoNew Member
Combining Columns from Multiple Tables Into a Single Table
Hello, I am new to PowerBI and have a question about combining tables. I have multiple queries that all pull different numbers and types of columns. There are some columns that contain the same t...
Analystmate
3 years agoHelper II
Q630 You can achieve desired using the "Append Query as New" feature in Power query.
Sharing below steps.
Load all table in power Query > Select "Append Query as New" form the home tab.
If tables more two select "Three or more table " > Select all required tables from the Available table list then add.
Result
Q630
3 years agoNew Member
Hi Analystmate, thanks for your reply. I tried your proposal and realized it would not work because some of the fields I want to combine are not part of the original queries. I updated my original question with more details to explain that.