Forum Discussion
Yulius
9 years agoFrequent Visitor
Unable to get data from Project Online Custom List
I had a problem, create a custom list does not appear in the Power BI by using the URL: https://abcd.sharepoint.com/sites/pwa/_api/projectdata. No one knows why my custom list does not appear ...
jmking
9 years agoRegular Visitor
From Paul Mather:
The OData API (_api/ProjectData) just surfaces data from the Project Web App database reporting schema. The reporting schema doesn't include custom columns from the Issue or Risks list - same limitation as Project Server 2007, 2010 and 2013 - it is by design.
To get that data you will need to query the List REST APIs, an example that mght help you get started can be seen below: