Forum Discussion
Unable to get data from Project Online Custom List
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
Hi 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 ZhangHi Anonymous,
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?
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-custom-list-data-reporting-with-odata-connection-bi-reports-in-project-online-2013?forum=projectserver2010general
Thanks,
Lydia Zhang