Forum Discussion
Data connection SharePoint
The following method and walkthrough is a common and easy-to-use pattern provided by Wyn Hopkins that I have used often. It is one thing to connect to the folder, and quite another to combine the files. This works well for a number of file formats including Excel and CSV.
Magically combine Excel files From SharePoint Folder with bonus debugging tip!
The following method and walkthrough is a common and easy-to-use pattern provided by Wyn Hopkins that I have used often. It is one thing to connect to the folder, and quite another to combine the files. This works well for a number of file formats including Excel and CSV.
Magically combine Excel files From SharePoint Folder with bonus debugging tip!
Thanks to you all for replying. I got it done!
Hello Erik1980 , and glad to hear you were successful! If you have many folks in your organization who store files in SharePoint Online (and yes OneDrive), share Wyn's video with them, and take advantage of handling like this in Power BI Power Query or Excel Power Query. Folks will be much happier.