Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

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 Ec...
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

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