Easy Tech TutsHow to Connect SharePoint List to Power BI (Direct Connection) Easily 2026
By Impran M NLast checked against official docs
If your team tracks work in a SharePoint list, you can pull it straight into Power BI with no CSV exports. Power BI Desktop ships a dedicated SharePoint Online list connector for this, separate from the SharePoint folder connector that sits next to it.
The setup is short. What goes wrong is usually one of three things: a list URL pasted where Power BI wants the site URL, the wrong view mode, or a list with too many lookup columns for the 2.0 connector. This guide covers the click path and all three.
Before you start
- Power BI Desktop installed
- A work or school account with at least read access to the SharePoint site and the specific list
01Copy the site URL from SharePoint
Open the list in your browser, then click Home in the site's navigation pane (or the site icon at the top). Copy the address from the browser bar at that point.
It should look like https://yourcompany.sharepoint.com/sites/yourteam and end there. This is the address the connector asks for.
Microsoft's own troubleshooting note says to supply the root address of the site "without any subfolders or documents", so a link to the list itself, or one ending in /Lists/Tasks/AllItems.aspx, is the wrong thing to paste. While you're in SharePoint, check the list has the columns your report needs. Adding one now is easier than discovering the gap halfway through building visuals.
02Open Get Data and pick SharePoint Online list
In Power BI Desktop, click Get data and choose More to open the full catalog. SharePoint folder shows up near the top of the All list, under File.
Skip it. That connector reads files in a document library, not rows in a list.
The one you want is SharePoint Online list, filed under Online Services. Typing SharePoint into the search box finds it faster than scrolling. Select it and click Connect.
03Paste the site URL, then choose implementation and view mode
The SharePoint Online Lists dialog has three settings. Paste the root site URL into Site URL; hovering the info icon shows Microsoft's own reminder not to include subfolders.
An invalid address puts a warning icon next to the box before you even click OK. Implementation offers 2.0 and 1.0.
Pick 2.0 for new reports. It uses a newer API and has been generally available since September 2022.
Choose deliberately, though: Microsoft states 2.0 isn't backwards compatible with 1.0, so flipping an existing report from one to the other can break the queries built on it. Under Advanced options, View Mode has two choices.
All returns every user-created and system column in the list. Default returns only the columns in whichever view is set as the list's default in SharePoint, so if you want a trimmed column set, edit or create that default view in SharePoint and pick Default here. There is no option to pick any other named view.
04Sign in and pick the list in Navigator
The first time you connect to a site, Power BI asks how to authenticate. For SharePoint Online, choose Microsoft account and sign in with your work account, then pick which level the credentials apply to (the site URL is the usual choice) and click Connect.
Navigator then shows every list on that site. Tick only the ones the report needs. Click Load to bring them in as-is, or Transform Data to open Power Query first and drop the columns you don't need.
05Publish and set a refresh schedule
Once loaded, the list behaves like any other table. Build your visuals, then publish to the Power BI service so it can refresh without you.
In the service, open the workspace, select the semantic model, and choose Refresh > Schedule refresh. If the schedule toggle is greyed out, open Data source credentials on the same page and sign in to the SharePoint source first.
Then turn on Configure a refresh schedule and pick your time slots. SharePoint Online is a cloud source, so no on-premises gateway is involved.
When it doesn't work
The connection fails, or Navigator comes back empty
Why: The Site URL points at the list, a subfolder or a page instead of the site root.
Fix: Trim the address back to the site itself, e.g. https://contoso.sharepoint.com/sites/yourteam, and reconnect.
With Implementation 2.0 the query fails on a list with many lookup columns
Why: The 2.0 connector uses a different API that is subject to SharePoint's limit of 12 join operations per query, so pulling more than 12 lookup-type columns at once fails.
Fix: In SharePoint, set a default view with fewer than 12 lookup columns, then choose Default under View Mode.
View Mode is set to All, but some columns are still missing
Why: The list's default view in SharePoint is a Calendar or Board view. SharePoint then returns only that view's columns, and Microsoft documents this as by design.
Fix: Change the list's default view to a standard list view in SharePoint and refresh.
Date/time values are several hours off (Implementation 1.0)
Why: The SharePoint API sends times in UTC. The browser converts them to your time zone; the 1.0 connector does not.
Fix: In Power Query, change the column type to Date/Time/Timezone and apply DateTimeZone.ToLocal to convert it.
Frequently asked questions
What URL should I enter in the connector?
The root URL of the SharePoint site, such as https://yourcompany.sharepoint.com/sites/yourteam. Not the list's own link and not a subfolder. Clicking Home in the site's navigation and copying the address bar gets you the right one.
Should I use Implementation 2.0 or 1.0?
2.0 for anything new. The one reason to stay on 1.0 is an existing report built on it, because the two versions aren't backwards compatible. Lists with more than 12 lookup columns also hit a limit that only applies to 2.0.
What's the difference between the All and Default view modes?
All pulls every user and system column. Default pulls only the columns in the list's default view in SharePoint. There's no way to target a different named view from this dialog.
Can the report refresh automatically?
Yes, once published. Set it under Refresh > Schedule refresh on the semantic model. Pro allows up to 8 scheduled refreshes a day and Premium/PPU up to 48. Power BI switches the schedule off after four consecutive failures, so check Refresh history if data stops updating.
Can I combine several lists in one report?
Yes. Tick several lists in Navigator, or repeat Get Data for lists on other sites, then relate them in the model view.
Sources and last check
The Get Data catalog and connector dialog come from a walkthrough recording in Power BI Desktop. The site URL rule, implementation versions, view modes, the 12-join limit and the refresh steps and limits were re-checked against Microsoft Learn documentation in September 2026. That check corrected this guide's earlier suggestion that View Mode could target any specific view; the only options are All and Default.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
