Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Import OneDrive File or Folder using Power Query. EMT 1755

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1755.xlsx
Learn how to import a file or a folder filled with files into Excel using Power Query.
(00:00) Introduction
(00:06) Import file from OneDrive. Use From Web Power Query Connector.
(01:25) Import files from Folder from OneDrive. Use From SharePoint Folder Power Query Connector.
(03:34) Refresh Power Query Output
(03:49) Share files
(04:11) Summary

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunMon, September 20, 2021 7:50pm