SharePoint.Tables
A SharePoint Online site's lists and libraries, each list's items as a table of its visible columns.
Group: Online services. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
SharePoint.Tables(url as text, optional options as nullable record) as table| Parameter | Type | Description |
|---|---|---|
url | text | The site's address, https://<tenant>.sharepoint.com/sites/<site>; a list's or page's address in the site works too. |
options | nullable record optional | Accepted as Power Query writes it (Implementation, ViewMode); none is read. |
Returns
table. Id, Title, Name, Items (the list's rows) and Kind ("List" or "Library"), a row per list the site shows.
Remarks
- Items has the list's own columns and ID, Title, Created, Modified, Author and Editor, named as their display names read, the way Power BI's SharePoint Online list connector (2.0) shows them. A lookup or person column holds the title (a list of titles when it allows several); a hyperlink column its address; a library's file name is Name.
- Items are read 5,000 at a time, every page of the list.
- Signed in with your Microsoft work account: the studio asks the first time this computer reads the source, and keeps the sign-in on this computer only.
Examples
A list's items
SharePoint.Tables("https://norwayanalytics.sharepoint.com/sites/sales", [Implementation = "2.0"]){[Title = "Orders"]}[Items]Result: not shown here: it needs a SharePoint Online site and a sign-in.