Updated on

Folder.Contents is a Power Query M function that retrieves a table containing information about each folder and file found in the specified folder path. The function returns a table with folder and 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 folder and file found in the folder path. Each row contains properties of the folder or file and a link to its content. The options parameter is currently intended for internal use only.

Other functions related to Folder.Contents are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: