Forum Discussion
Consolidating data from various excel files in different sharepoint folders
Hi all, I have a Power BI report in the Service for which I have the necessitiy to import data from various excel files in different subsites and folders in sharepoint. My question would be wet...
Hi ITManuel
You can create a single folder on the site then put the all related excel files to the folder, then in Power BI, when getting data, you can choose from Sharepoint folder, then combinr these excel files, you can refer to the following link.
Consolidate Multiple Excel Files in SharePoint using PowerQuery - Excelerator BI
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
the excel files will need to stay in different folders, since there are X projects and X folder structures, one for each project.
Br