Connect to a Folder

  1. In the POWER QUERY ribbon tab, click From File > From Folder.
  2. In the Folder dialog box, browse for or type a folder path to import or link to a file.
  3. Click OK.

Formula Example

= Folder.Files("C:\Documents")

 
 
Applies to:
Excel 2013, Excel 2010