Updated on

Folder.Files is a Power Query M function that retrieves a table containing information about each file found in the specified folder path and its subfolders. The function returns a table with file properties and a link to their content.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


   path as text,
   optional options as nullable record,
) as table


Returns a table containing a row for each file found in the folder path and all its subfolders. Each row contains properties of the file and a link to its content. The options parameter is currently intended for internal use only.

Learn more about Folder.Files in the following articles:

Other functions related to Folder.Files are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: