Forum Discussion

yuvanne_11's avatar
yuvanne_11
Frequent Visitor
4 years ago
Solved

Appending Queries

truptis amitchandak  Hi, I am having a problem with appending queries.  As in the below image I am having 5 tables that I imported from excel. I want to combine all the 5 tables and have them as o...
Need Help
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi yuvanne_11 

    Append query is straight forward in Power BI.

     

    1. Add one custom column on all your table like "May 2021" or may be a file name like below

     

    2. Append as new query. if the names of the columns are same across all the files then it will be appended in same column.

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi yuvanne_11 

Append query is straight forward in Power BI.

 

1. Add one custom column on all your table like "May 2021" or may be a file name like below

 

2. Append as new query. if the names of the columns are same across all the files then it will be appended in same column.

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin