Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Morning everybody!
Refer to the subject, i don't really know how to get data (efficient way) from a folder. Below i will give an example;
First step.
This is the location of the file. This file i named it "ACTUAL".
So as we can see, this show that it get all the files inside the folder right?
So here is the real problem. At the drop down menu, do i need to choose one-by-one of the files to load it? because when i try click at "first file Y20M20", it only load that file. What i really want is it can load & combine all of the files. The column name for all the files is exactly same.
So is there any way that i can try?
Solved! Go to Solution.
@New_be , refer these
https://powerbi.tips/2016/08/load-multiple-excel-xlsx-files/
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
https://www.youtube.com/watch?v=iz35tPBqBes
https://www.youtube.com/watch?v=9sfCDCpWTfc
Hi @New_be ,
The file you will choose behind "Sample File" is used to determine the correct file format to use, such as text, Excel workbook, or JSON file. And you don't need to choose one-by-one of the files to load it , just click option "Combine & Transform Data ".
To combine binary files in Power Query Editor, select Content (the first column label) and select Home > Combine Files. Or you can just select the Combine Files icon next to Content.
For reference:
Combine files (binaries) in Power BI Desktop
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi New_be,
I usually select Transform Data from the dialog.
In the Query Editor, I then click on the Combine Files at the column header of the Content Column.
So far I didn't have issue using this approach.
Hope that helps.
Regards,
Jeff Ong
@New_be , refer these
https://powerbi.tips/2016/08/load-multiple-excel-xlsx-files/
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
https://www.youtube.com/watch?v=iz35tPBqBes
https://www.youtube.com/watch?v=9sfCDCpWTfc
Hi @New_be
Check the below link
https://www.youtube.com/watch?time_continue=134&v=9sfCDCpWTfc&feature=emb_logo
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |