Merge multiple excel files into sharepoint folder

[Syndicate_Admin]

Hello, I have 4 folders created with excel workbooks that follow the same column-level scheme.

When I try to compile files using the binary option, a table is created that only contains data from Ecuador but the other plants are missing.

Alklguien knows how I can solve this problem? or something I'm doing wrong? xq I should generate a table with all countries

The steps I do is go to content, merge taking first file.

[v-jayw-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please refer this blog about combining Excel files on SharePoint folder.

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/ .

Best Regards,

Jay