cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Get Data (Excel) From a folder

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;

 

ym0.PNG

First step.

 

ym.PNG

This is the location of the file. This file i named it "ACTUAL".

 

ym3.PNG

So as we can see, this show that it get all the files inside the folder right?

 

ym4.png

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV
4 REPLIES 4
Highlighted
Community Champion
Community Champion

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? Please consider accepting it as the solution to help the other members find it more quickly.


Appreciate your Kudos, Press the thumbs up button!!👍


Regards,
Pranit


Highlighted
Super User IV
Super User IV
Highlighted
New Member

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

Highlighted
Community Support
Community Support

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.

combine-files in folder.png

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors