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.