by Wyn Hopkins
Combining Multiple Files from a Folder
How to use Power Query for Excel and Power BI to consolidate multiple files into a single table of data, whether you’re using OneDrive , SharePoint or a traditional network folder.
As well as showing the basic steps, this video explains the inner workings of the Power Query helper functions so you fully understand how it works
And here’s how you connect to a file on Sharepoint and OneDrive