combine files from sharepoint document library

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.