Forum Discussion
Solved
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; First step. This is the location of the ...
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.