Unable to get data from Project Online Custom List

[Yulius]

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"

[Ludia]

http://community.powerbi.com/t5/Issues/HTML-formatting-for-Project-Online-Power-BI-Reports/idc-p/343...

You can refer my blog about it, if you still have problem, just let me know, hope to help you on it

[paulgagni]

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.  paulgagni@gmail.com

[jmking]

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:

https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-proje...

[v-yuezhe-msft]

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 Zhang

[Yulius]

Hi @v-yuezhe-msft, 

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

[v-yuezhe-msft]

Hi @Yulius,

Have you refreshed imported table in Power BI Desktop after you add new field in issues?

Thanks,
Lydia Zhang

[Yulius]

Hi @v-yuezhe-msft, 

I click on the refresh power bi desktop menu, but the custom fields are not appearing.

and I then do a "get data" using "OData Feed", but still the result of my custom fields do not appear in the list issue, only the default field issues that arise.

is this limitation of power bi to the custom field in Issue List?

[v-yuezhe-msft]

Hi @Yulius，

To get custom fields and custom lists in Power BI Desktop, please add parameters in your URL, for more details, please review the following blogs and similar thread.

https://pwmather.wordpress.com/category/reporting/
http://blogs.agorainc.com/post/querying-project-server-odata.aspx
https://social.technet.microsoft.com/Forums/en-US/991d85ad-b9d1-4d41-9814-f16f92699cfa/project-site-...

Thanks,
Lydia Zhang