Folder.Files

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

Syntax

Folder.Files(
   path as text,
   optional options as nullable record,
) as table

Description

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: https://learn.microsoft.com/en-us/powerquery-m/folder-files