SharePoint.Contents is a Power Query M function that returns a table containing rows for each folder and document found at a specified SharePoint site. The function returns a table with folder or file properties and content links.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
SharePoint.Contents(
url as text,
optional options as nullable record,
) as tableDescription
Returns a table containing a row for each folder and document found at the specified SharePoint site, url. 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.
Related functions
Other functions related to SharePoint.Contents are:
