Power BI: Read data from SharePoint List

In this article, I will show

How to query data from SharePoint List / Library in Power BI.

  • Using OData Feed.
  • Using SharePoint List Connection.

Get SharePoint List/Library Using OData Feed

Let us first briefly define what the OData?

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 information exposed by SharePoint.

Steps

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

  • Click Connect.
  • 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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s