Forum Discussion
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 in the Power BI,
Please help me.
Note: my custom list " Change Request"
8 Replies
Hi Yulius,
How do you connect to Project Online? Using Project Online content pack in Power BI Service or connect to Project Online in Power BI Desktop?
Based on my research, Project Data ODATA feed only contains the default Project Site lists and default columns (Risks, Issues, etc.), custom lists and columns are not included. For more details, please review this article.
Thanks,
Lydia ZhangHi Anonymous,
i using connect to Project Online in Power BI Desktop.
yes, my custom list no found and I make an extra field in the Issue List, but even then did not show up as well.
how to overcome these problems? any idea ?
Thanks and Regards,
Yulius
Hi Yulius,
Have you refreshed imported table in Power BI Desktop after you add new field in issues?
Thanks,
Lydia Zhang
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:
You can refer my blog about it, if you still have problem, just let me know, hope to help you on it
Hello Ludia!
I am in the process of getting Project Online setup for our company and I read through all the informaiton, but could use some assistance if you are help to help out. [email protected]
