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-easonf-msft · Accepted solution]

Hi, @Syndicate_Admin 

Please refer to this document about how to import multiple Excel files in Power BI.

Import Multiple Excel Files In Power BI 

Note that in order to combine files Power Query requires that each table structure be consistent.

And if there a link for "Load more" next to the prompt "List may be incomplete",you can also try it to expand the

list.

Best Regards,
Community Support Team _ Eason