Updated on

SharePoint.Files is a Power Query M function that returns a table containing rows for each document found at a specified SharePoint site and subfolders. The function returns a table with folder or file properties and content links.

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


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


Returns a table containing a row for each document found at the specified SharePoint site, url, and subfolders. Each row contains properties of the folder or file and a link to its content. options may be specified to control the following options:

  • ApiVersion : A number (14 or 15) or the text "Auto" that specifies the SharePoint API version to use for this site. When not specified, API version 14 is used. When Auto is specified, the server version will be automatically discovered if possible, otherwise version defaults to 14. Non-English SharePoint sites require at least version 15.

Other functions related to SharePoint.Files are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: