Forum Discussion
Recoba88
Helper III
Helper IIIConsolidate multiple excel files from Sharepoint to Power Query
Hi,
I want to combine multiple excel woorkbooks that located on SharePoint in Power Query
For example :
1. file 1
2. file 2
3. file 3
I need to see all the files in power query (all the files have the same structure)
Thanks,
Igor
2 Replies
v-sihou-msftMicrosoft Employee
To combine multiple Excel files in to Power BI, you can get data from "SharePoint Folder". Then use "Combine Binaries". For more details, please refer to: Combining Excel Files hosted on a SharePoint folder with Power BI
Regards,
Recoba88Thanks for quick answer but it isn't work . I use it in Excel 2016 (Power Query) and not Power BI Desktop
this is what I get when I press the button above Content Column (Binary)