Consolidate multiple excel files from Sharepoint to Power Query

[Recoba88]

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

 

[v-sihou-msft]

@Recoba88

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,

[Recoba88]

Thanks 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)