Easy Tech TutsHow to Integrate Power BI With SharePoint and List, Connect it Easily 2026
By Impran M N
Pulling live SharePoint Online lists or Microsoft Lists directly into Power BI avoids the messy manual Excel exports and stale copies that come from managing project or inventory data by hand. This guide covers connecting to the correct site address and shaping the data once it's inside Power Query.
01Copy the root SharePoint site URL
Grab the exact root site address rather than the full list URL, since using the complete list link often causes fatal connection errors.
02Connect using the SharePoint Online List connector
In Power BI Desktop, choose the native SharePoint Online List connector and paste in the root URL you copied.
03Select your lists in the Data Navigator
Use the Data Navigator panel to browse and select the specific lists you want to import into your model.
04Expand multi-value fields in Power Query
Some SharePoint columns store multiple values, so use Power Query to expand these fields into usable table columns.
05Publish and schedule refresh
Publish your report to the cloud workspace and configure a scheduled refresh so the data stays synchronized with your live SharePoint lists.
Frequently asked questions
Why does my SharePoint connection keep failing?
This is most often caused by pasting the full list URL instead of the root site address, which the connector requires.
Can I connect to Microsoft Lists the same way?
Yes, Microsoft Lists uses the same underlying SharePoint infrastructure, so the same connector and root URL approach applies.
Do I need a gateway to refresh SharePoint data?
Since SharePoint Online is cloud-hosted, a gateway generally isn't required for scheduled refresh, unlike on-premises data sources.
Why are some of my list columns showing as records instead of values?
This happens with multi-value or lookup fields, which need to be expanded in Power Query before they display as normal columns.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
