Forum Discussion
Consolidating data from various excel files in different sharepoint folders
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,
any further ideas in relation to the topic?
I was trying to set a separate Power BI report in the service which combines the files from the different Sharepoint folders, but each Sharepoint folder will need its dedicated Data gateway connection in the service in order to allow scheduled refresh to run, i do not want to have a connection for each SharpePoint folder to maintain. I also tried Power Automate, but wasn't successful so far.
Any help or ideas would be much appreciated.
Thanks & Br