cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gracylayla Regular Visitor
Regular Visitor

Power BI - Get Data From SharePoint List / Library

In this article, we will show how to get the data from SharePoint in Power BI.
  1. Using OData Feed.
  2. Using SharePoint List.

Get SharePoint List/Library Using OData Feed

The Open Data Protocol (OData) is a data access protocol for the web.
  • OData provides a uniform way to query and manipulates datasets through CRUD operations (create, read, update, and delete).
  • OData defines an abstract data model and a protocol that let the client access the information exposed by SharePoint. 

Steps

  • Open Power BI Desktop and at Home Tab, click on Get Data > OData Feed.
  • Type the OData Feed URL for the SharePoint "http://siteurl/_vti_bin/listdata.svc" and click Connect. 

    • ListData.svc provides a way of getting information from a list using REST.

  • In Navigator dialog, select the required list and 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 be prompted 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.

 

1 REPLY 1
Super User
Super User

Re: Power BI - Get Data From SharePoint List / Library

Hi there

Is this a question or an article/blog post?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 121 members 1,566 guests