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: