Forum Discussion
Accessing data in Project Online custom list
Hi Maggie,
Thanks very much for your reply.
I have previously attempted to connect to the list however the article below and others I have found state to connect to the https://<tenantname>.sharepoint.com/sites/pwa/_api/Projectdata. As this is a custom list, it does not show in the API.
My issue is defining to the correct string in Power BI to connect to the list per project in Project Online.
Many thanks
Simon
Community SupportHi simoncurrier
The Project Data ODATA feed only contains the default Project Site lists and default columns (Risks, Issues, etc.), custom lists and columns are not included.
To connect to custom list within Project web application, please check the sample code in the blog and similar thread below.
https://pwmather.wordpress.com/2016/01/05/want-to-query-cross-project-site-sharepoint-lists-in-proje...
https://community.powerbi.com/t5/Issues/HTML-formatting-for-Project-Online-Power-BI-Reports/idc-p/34...
Best Regards
Maggie
Hello v-juanli-msft ,
after following the above article I'm able to get the required output under Power BI desktop but once I publish the report, refresh is not working. Any idea v-juanli-msft,
Dear simoncurrier ,
Can you please help me with this?
please find the below query which I have raised on power bi community.
