Combine multiple Excel files using PowerQuery

This video will show you how you can connect to a folder and then process multiple Excel files with table-like structures.
It is an easy-to-follow video that will also explain the M function called Excel.Workbook

#powerbi #excel #data #m

[SetYourBarTo]

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

[Giridharan]

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

[kebincui]

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

[wayneedmondson]

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

[kinchannel]

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

[maksim]

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

[md.ebnulhossain]

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.

[xGhstx]

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.

[rafiudeensarfaraz]

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

[rameshu]

Will it work in the CSV file format..?