Get SharePoint List items in Power BI

In this article, I will show

How to query 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 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

  • 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
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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s