TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Post an article
Translate this page
Powered by
Microsoft® Translator
Wikis - Page Details
First published by
Mohamed El-Qassas MVP
(MVP, Microsoft Community Contributor)
When:
31 Aug 2017 3:09 PM
Last revision by
George Chrysovaladis Grammatikos
(MVP, Microsoft Community Contributor)
When:
6 Sep 2018 11:31 PM
Revisions:
19
Comments:
10
Options
Subscribe to Article (RSS)
Share this
Engage!
Wiki Ninjas Blog
(
Announcements
)
Wiki Ninjas on Twitter
TechNet Wiki Discussion Forum
Can You Improve This Article?
Positively!
Click Sign In to add the tip, solution, correction or comment that will help other users.
Report inappropriate content using
these instructions
.
Wiki
>
TechNet Articles
>
Power BI: Two Way To Get Data From SharePoint List / Library
Power BI: Two Way To Get Data From SharePoint List / Library
Article
History
Power BI: Two Way To Get Data From SharePoint List / Library
Table of Contents
Introduction
Get SharePoint List/Library Using OData Feed
Steps
Get SharePoint List/Library Using SharePoint List Connection
Steps
Applies To
Conclusion
See Also
Introduction
In this article, we will explore two way to get data from SharePoint List / Library in Power BI.
Get SharePoint List/Library Using OData Feed
First, let's briefly define the OData?
The
Open Data Protocol (OData)
is a data access protocol for the web.
OData provides a uniform way to query and manipulates data sets through CRUD operations (create, read, update, and delete).
OData defines an abstract data model and a protocol that let the client access information exposed by SharePoint.
Steps
Open Power BI Desktop > at Home Tab > Click on Get Data > Select OData Feed.
Type the OData Feed URL for the SharePoint "
http://siteurl/_vti_bin/listdata.svc
" > Click Connect.
ListData.svc
provides a way of getting information from a list using REST.
In Navigator dialog, Select the required list > Click Load.
You should now find the list fields in Fields section, and you should be ready to build your report from SharePoint list items.
Note
In case the current user is not authorized to connect to the site, you will prompt to set the right credential as shown below
Get SharePoint List/Library Using SharePoint List Connection
Power BI Desktop also provides a direct data source for the SharePoint list as shown below:
Steps
Open Power BI Desktop > at Home Tab > Click on Get Data > Click More.
In Get Data dialog, Search for SharePoint > Select SharePoint List > Click Connect.
Provide the SharePoint Site URL > Click OK.
In Navigator dialog, Select the required list > Click Load.
You should now find the list fields in Fields section, and you should be ready to build your report from SharePoint list items.
Applies To
SharePoint 2016.
SharePoint 2013.
Conclusion
In this article, we have explored two methods to get data from SharePoint List/Library in Power BI.
See Also
The official Microsoft Power BI website
.
Power BI community forums
(Moved from the MSDN & TechNet Forums to separate interface).
Power BI Learning Resources.
Complete basic operations using SharePoint REST endpoints
.
Power BI: Show and Sort Slicer By Month or Quarter Name
Back to Top