Microsoft MVP | Author | Speaker | Power BI & Excel Developer & Instructor | Power Query & XLOOKUP | Purpose: Making life easier for people & improving the quality of information for decision makers
The YouTube video by "Wyn Hopkins [MVP]" aims to demonstrate the method to enter a File Path to Combine Files from SharePoint including the sub folder option. The video is precisely divided into multiple sections.
Alongside the video discussion, the presenter mentions about a file which may help viewers to understand the procedures more accurately. However, Hopkins warns not to get distracted by any external pages or blog references for this explicit topic. Power BI, the tool, and Excel solutions are more emphasized on their development by the team of Access Analytic in Australia and training sessions are organized worldwide.
The author of the video has evidently mentioned about his book "Power BI for the Excel Analyst", but no advertisement or selling was intended in the video. Lastly, the author shared his contact information for viewers who wish to maintain a professional connection.
The author tries to encapsulate the complex procedure of entering a File Path to Combine Files from SharePoint including the sub-folder option using Power BI and Excel. The tutorial begins with an introduction which is proceeded by explaining the basic way of combining the files. This moves on to using List.Transform Method and ends in developing a custom function to obtain files from folder including sub folders.
The video appears to be greatly helpful for its viewers as it demonstrates complex methods in quite feasible ways. Power BI and Excel users can learn useful techniques to optimize their tasks. The entire video appears to be plain simple without any promotional content or external references, making it easy for the viewers to concentrate.
In this YouTube video, the presenter offers a detailed guide on how to combine files from a SharePoint folder, including files from sub-folders. The process is explained from 00:00 - 03:52, with a step-by-step walkthrough of the basic technique. From 03:52 - 07:44, the use of the List.Transform function is explained, followed by the demonstration of a custom function to retrieve files from folders, including sub-folders.
The files used in the video are available for download via this link.
The presenter, Mark Proctor, whose blog can be accessed at Excel Off The Grid, and his team at Access Analytic, develop Power BI and Excel solutions for clients in Australia and deliver training globally. They are also the authors of the book "Power BI for the Excel Analyst". Further information about their work and training courses can be found on their website.
Another key contributor to the video is Imke Feldmann, whose insights on improving file import from SharePoint in Power BI and Power Query can be accessed on her website.
The presenter's contact information and other links are available at wyn.bio.link.
Microsoft specialist, Microsoft professional expert, Microsoft certified professional, Microsoft certified expert, Microsoft solutions expert.