Combine multiple Excel files using PowerQuery

Рет қаралды 19,881

Жыл бұрын

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
👉Need more assistance? Check our website at exceed.hr/en/services/
#powerbi #excel #data #m

Пікірлер: 14

@SetYourBarTo10 11 ай бұрын

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

@kebincui Жыл бұрын

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

@Giridharan952 Жыл бұрын

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

@wayneedmondson1065 Жыл бұрын

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

@user-uc8jf4nu8c 4 ай бұрын

excellent great job

@eziola Жыл бұрын

Awesome videos!

@oscargestosocarrera7287 Жыл бұрын

great content!

@kinchannel3264 9 ай бұрын

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

@xGh0stx6 Жыл бұрын

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.

@rameshu3091 9 ай бұрын

Will it work in the CSV file format..?

@rafiudeensarfaraz5898 10 ай бұрын

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

@maksim0933 Жыл бұрын

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

@ExceedLearning Жыл бұрын

Not sure if you will benefit from nesting filter arguments before expanding all the tables, since Excel does not support query folding.

@md.ebnulhossain476 Жыл бұрын

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.