Import All Excel Files from a Folder in PowerBI | Power Query | MiTutorials

Import All Excel Files from a Folder in PowerBI | Power Query | MiTutorials

[Bungo]

Great video. Just what I wanted. Very well presented. I like that you are teaching like you are sitting beside me, use simple examples and don't assume that the viewer knows too much! Thanks a mill.

[kogxzlb]

This was a great demonstration and showed me exactly what i was looking for :)

[alexismasson]

Great! Thank you for your video! It was very helpfull. Thanks!

[jraj]

Awesome video, it served my purpose .Thank you. 🙂

[cesarmr]

Amazing. Thank you very much. This is exactly what I wanted!

[opowerplatform]

Hi. While I think the answer is no or unlikely.. but possible to dynamically and intelligently connect to a changing folder of excel files that might have a dozen different sheets formats. We have a project where we are downloading social media stats from some service. We were planning to build interfaces to neatly aggregate a single row from those different sheets into 12 separate SQL tables for reporting. But wondering if we just had a bunch of files with a bunch of sheets in a folder if PBI could somehow understand the file and worksheet data model to associate and aggregate like data?

[skyeparker]

I will have many xlsx files in a folder but I don't think the columns and sheets will all be the same over time because we will be modifying our export process over time. Can power bi search through these sheets and search for data even though it may be in different locations file to file?

[BeanTricotando]

I took only 5 minutes to do something that it was taking hours, I discovered that some names was miscrited. Thank you!

[alibaroroh]

but i we change thats folder source (like from c to d). its doesnt work.. can you explain ? tk

[anilreddykanthala]

How to make each sheet in folder as table (individual tables)

[samimohammedm]

Hi, Thank you for the very helpful video. Looking forward to more content from you. Do have a question, How would you solve for all the invalid data errors while importing excel sheet with '#N/A'?

[kirankumarv]

Hi sir can you please make interview questions and answers for experianced

[Mahesh]

what if the data is in csv files, can what to write instead of excel.workbook ?

[sahinsahin]

Someone can tell me please.How can i change the sources name. All have them has .xlsx name at the end and i have 81 files is there a quick way to erase .xlsx part from all files?

[nazarkamal]

Why cant we do combine and transform data as there is lot of workbooks as well sheets

[malarmohanam]

some of columns are missing after loading data using power query

[sidheequekp]

What will happen if i add a new excel sheet into the folder, will it automatically fetch the information from it ?

[abrahamjesse]

when i create the custom column I dont get 'tables' but errors, how can i fix that?

[Mahesh]

what if in case we have multiple sheets with different columns & data how to load this type of data....

[andre]

i do not want to combine my tables. i only want to load multiple tables from a folder. how can i do that??