Connect SharePoint Custom List Data with Power BI using O Data

Hi muneebch041 ,

You can refer the following links to get it:

Power BI with SharePoint data: The Ultimate Guide

https://siteurl/_vti_bin/listdata.svc

Power BI - Get Data From SharePoint List / Library

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.

---

Best Regards