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

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

Рет қаралды 73,412

Күн бұрын

Пікірлер: 39

@63Bungo Жыл бұрын

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.

@RobWright-g3p Жыл бұрын

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

@asaravana3966 2 ай бұрын

It's a great video thanks for sharing

@cesarmr111 8 ай бұрын

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

@zerobars3 7 ай бұрын

Good explanation thanks for posting

@HimSha07 6 ай бұрын

Thanks a lot for this video. Very useful

@itaishabtai2964 11 ай бұрын

Great Video , thanks a lot.

@jraj2380 Жыл бұрын

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

@skyeparker5822 10 ай бұрын

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?

@alexismasson8020 3 жыл бұрын

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

@Mahesh717 Жыл бұрын

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

@MITutorials Жыл бұрын

Use Csv.Document

@BeanTricotando 11 ай бұрын

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

@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'?

@MITutorials Жыл бұрын

It really depends what you want to do with those errors. Remove the rows or Make them null values etc.

@samimohammedm Жыл бұрын

@@MITutorials need to make it null and retain the rest of the row

@o365powerplatform9 2 жыл бұрын

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?

@MITutorials 2 жыл бұрын

If there is a logic of how PowerBI should fetch the files it is possible. Dynamically changing folder - please provide more explanation to this.

@nazarkamal8831 Жыл бұрын

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

@kirankumarv178 Жыл бұрын

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

@alibaroroh9355 Жыл бұрын

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

@Mahesh717 Жыл бұрын

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

@anilreddykanthala3607 2 жыл бұрын

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

@sahinsahin5275 Жыл бұрын

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?

@madhusudhanreddyt2838 7 ай бұрын

use replace values option in power query editor and replace .xlsx with empty string