Folder.Contents

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

Syntax

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

Description

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:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/folder-contents