Combine multiple Excel files using PowerQuery

i was trying a lot since a couple of days to combine and i was getting errors, until i watched your video and my problem solved.. you helped me., thx. but if i add new column on one of the main tables, i can't see data comes into the querytable

Will it work in the CSV file format..?

i have 5 excel workbooks with all the sheets named the same. what I want to do is combine the 5 excel files into one workbook with the sheets in each of the excel file file merged together with the same sheet name respectively. for example in excel file 1 there are sheet names sales and items and in excel file 2 there is also sheet names sales and items. what I want to do is combine the two excel files with each other so that excel file 1 sales and excel file 2 sales are merged together and excel file 1 and excel file 2 items are merged together. Is there a way for this? And I want the excel file to be updated on a regular basis maybe weekly once or twice if there are any changes into the 5 excel files I do not want to put them all in one destination file. I want to keep the 5 excel files as it is but combine them as one excel file where it gets updated frequently if there are any changes into the 5 excel workbooks

Liked, shared, and followed along with my own workbooks. Thank you for the video.

I have to combine data from multiple worksheets to a single worksheet. But my data have 1605 columns. When I bringing the data it only imports only 256 columns. What is the solution to bring all 1605 columns.

Hello,
Thank you for this it is very helpful !

However, I have tried this with csv files and I keep getting this error "DataFormat.Error : the external table is not in the expected format"
Could someone help ?

I am able to do a query individually but not alltogether like in the video.

great content!

Just found your channel a couple of weeks ago, but its already a favorite. Phenomenal content and explanations! You’ve taught me a lot about M code already.

Very nice! Thanks for the tips. Thumbs up!!

How to make these steps nested so that query to be lightning fast? Can we filter before expanding tables?

Awesome videos!

Perect. Thanks for sharing and look forward to more videos from you.👍

Super sir, you are on track after long time.....wishes for many videos.