Load a SharePoint List in Power Query M

Connects to a SharePoint list and loads its items as a table.

File HandlingIntermediatesharepointlistconnector

Power Query M code

let
    Source = SharePoint.Tables("https://yourcompany.sharepoint.com/sites/YourSite", [ApiVersion = 15]),
    YourList = Source{[Id = "YourListName"]}[Items]
in
    YourList

Notes

Replace the site URL and list name/ID with your own; SharePoint.Tables lists all available lists if you're not sure of the exact ID.

Requirements

Access to a SharePoint list on the target site.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Load a SharePoint List.