Merging .csv files from different share point subfolders

[Anonymous]

Hi all, 

I would like to create a query to add aggregated table in power bi for one region for multiple .csv files (same format) to report on several countries. E.g. 

There is a share point folder "region A" which has two subfolders "country A" and "country B". 

I was able to draft a query that stops at navigating to "region A" folder. Any idea how to proceed further? 

[V-lianl-msft]

Hi @Anonymous ,

You can refer to the familiar thread:

https://community.powerbi.com/t5/Desktop/Combine-multiple-quot-FOLDERS-quot-not-files/td-p/133239 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Anonymous 

Clicking on the double headed arrow in the Content column header will expand the tables in that column and merge them.

Regards

Phil

[negi007]

@Anonymous If wish to merge two or more than two excel files you can do so. In the get data option, please select file -> folder . here you provide the folder location then all the files from the main folder and subfolder will be visible, you can then select files and mege them. Below screenshot will guide you in selecting the folder

[Anonymous]

@negi007 - my parent folder and subfolders are on share pointm therefore, this will not work. Also, As I mentioned above, I already got to the point how to navigate to subfolders - just do not know how to merge the files - see my screenshot above.