Forum Discussion
Accessing data in Project Online custom list
Community SupportHi simoncurrier
From this
"I have downloaded the Power BI reporting pack and am customising in Power BI Desktop. "
It seems you connet to Project Online with Power BI Service, then Download the report as a .pbix.
In Power BI Desktop, you need to add another table called "Project Updates" list from this Project Online site.
I suggest you connect to data (list in Project Online) through Power BI Desktop,
then manage relationships among this new added table and others
or Shape and combine data in Power BI Desktop.
Best Regards
Maggie
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
- v-juanli-msft
Hi 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.
