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.
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?
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'?
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?
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?
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.
It's a great video thanks for sharing
This was a great demonstration and showed me exactly what i was looking for :)
Good explanation thanks for posting
Thanks a lot for this video. Very useful
Amazing. Thank you very much. This is exactly what I wanted!
Awesome video, it served my purpose .Thank you. 🙂
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?
Great Video , thanks a lot.
what if the data is in csv files, can what to write instead of excel.workbook ?
Use Csv.Document
Great! Thank you for your video! It was very helpfull. Thanks!
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'?
It really depends what you want to do with those errors. Remove the rows or Make them null values etc.
@@MITutorials need to make it null and retain the rest of the row
I took only 5 minutes to do something that it was taking hours, I discovered that some names was miscrited. Thank you!
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?
If there is a logic of how PowerBI should fetch the files it is possible. Dynamically changing folder - please provide more explanation to this.
but i we change thats folder source (like from c to d). its doesnt work.. can you explain ? tk
How to make each sheet in folder as table (individual tables)
Why cant we do combine and transform data as there is lot of workbooks as well sheets
Hi sir can you please make interview questions and answers for experianced
when i create the custom column I dont get 'tables' but errors, how can i fix that?
If you're fetching a csv file use this instead. =Csv.Document
What will happen if i add a new excel sheet into the folder, will it automatically fetch the information from it ?
Yes!
@@MITutorials How to add new column into a particular sheet?
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?
use replace values option in power query editor and replace .xlsx with empty string
some of columns are missing after loading data using power query
Could you do this with 77 500K+ files?
i do not want to combine my tables. i only want to load multiple tables from a folder. how can i do that??
I am looking for same
I am looking for same
what if in case we have multiple sheets with different columns & data how to load this type of data....
My data is getting duplicated for some reason
Hi @MITutorials, Can I contact you personally regarding power bi session .Please provide your email