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

Continue reading “Power BI: Read data from SharePoint List”

Advertisements