combine files from sharepoint document library

[bzeeblitz]

i need to combine several files but same file structure that are stored in sharepoint site document library so please let me know if its possible to combine and load files in this context and i greatly  appreciate if you help me how to get data from sharepoint document library for combining files and load in power bi.

Thanks in advance

[v-linyulu-msft]

Thanks for the reply from vicky_, please allow me to provide another insight:

Hi, @bzeeblitz 
Thanks for reaching out to the Microsoft fabric community forum.

I think vicky_'s solution is indeed very good, making full use of the existing features of Power Query. However, you can also refer to the following documentation, which introduces the features of the Power Query SharePoint Folder connector and the supported products, including Excel, Power BI, Power Apps, etc. I hope this will be helpful to you:

For more details, please refer to:
Combine files overview - Power Query | Microsoft Learn
 

If you have any other questions or need further assistance, please feel free to let me know.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

Check out this article - https://learn.microsoft.com/en-us/power-query/combine-files-overview

you'll need to either navigate to your folder, or filter by folder pathm then click the two down-arrows in the "content" column, which will then walk you through how to combine all the files.