Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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
Proud to be a Super User!
@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
Proud to be a Super User!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |