Forum Discussion

DM0010's avatar
DM0010
Regular Visitor
3 years ago
Solved

Combining multiple tables in one visualization

Hello everyone!   I recently started to use Power BI at my work for more insightful visualizations of certain financials. I'm getting to know the program by watching (and reading) a lot of tutorial...
  • NikhilChenna's avatar
    NikhilChenna
    3 years ago

    Hi DM0010 , it is simple. if all the tables column names are same.
    1. Go to Power Query Editor select all the tables from your left hand side queries pane using Ctrl. 
    2. After that click on Append Queries button (Combine section) above ribbon . Attaching screenshot for your reference.

    3. Refer this link too for more details ,
    https://learn.microsoft.com/en-us/power-query/append-queries

     

    Regards,
    Nikhil Chenna 

     

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!

     

NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi DM0010 , it is simple. if all the tables column names are same.
1. Go to Power Query Editor select all the tables from your left hand side queries pane using Ctrl. 
2. After that click on Append Queries button (Combine section) above ribbon . Attaching screenshot for your reference.

3. Refer this link too for more details ,
https://learn.microsoft.com/en-us/power-query/append-queries

 

Regards,
Nikhil Chenna 

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!