Forum Discussion
Merge multiple excel files into sharepoint folder
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.
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
1 Reply
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