How to Connect SharePoint List to Power BI (Direct Connection) Easily 2026

Confirm the list you want to pull in actually has the columns your report needs — status fields, dates, owners, whatever you're planning to build visuals around. It's much easier to add a missing column in SharePoint before connecting than to discover the gap after you've already built half a report in Power BI Desktop.

In Power BI Desktop, click Get Data to open the full source catalog. You'll notice SharePoint folder listed under File, but that's for document libraries — a list of files, not structured list data. What you actually want is a level down in the catalog, under Online Services, where the dedicated SharePoint Online Lists connector lives.

Selecting SharePoint Online Lists opens a dialog asking for the Site URL — and this is the detail most people get wrong: it wants the root URL of the SharePoint site itself, not a link to the specific list or a subfolder within it. Paste something like https://yourcompany.sharepoint.com/sites/yourteam and nothing more; adding the list path onto the end causes the connection to fail or return nothing. Below that, an Implementation setting offers 2.0 or 1.0 — leave it on 2.0 unless you have a specific reason to fall back, since it's the newer, more reliable engine.

Expanding Advanced options reveals a View Mode dropdown, defaulted to "All - Retrieve all columns from a SharePoint list." This pulls every column regardless of whether it's shown in any SharePoint view, which is usually what you want for a report, but it can also drag in hidden system columns you don't need. If your list has a lot of internal metadata columns, switching this to a specific view can cut down the noise and speed up your refresh.

After confirming the site URL, Power BI's Navigator shows every list available at that site — pick the one you actually need rather than everything visible, since a busy SharePoint site can easily have a dozen lists unrelated to your report. You'll be prompted to authenticate with your organizational account if you haven't already; make sure it's an account with at least read access to that specific list, not just the site in general, since list-level permissions can be more restrictive.

Once loaded, list data behaves like any other Power BI table — build status trackers, feedback summaries, or timeline visuals directly from the columns you pulled in. Publish to the Power BI service and set a scheduled refresh so changes made in the SharePoint list, like a status update or a new row, show up in the report without anyone re-running the import by hand.