Forum Discussion

simoncurrier's avatar
simoncurrier
New Member
7 years ago

Accessing data in Project Online custom list

Hi,   I am trying (unsucessfully!) to access data in a custom list in Project Online.  I have created a "Project Updates" list within PWA - https://domain.sharepoint.com/sites/pwa/Lists/Project%20U...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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

hachishti's avatar
hachishti
Frequent Visitor
4 years ago

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.

https://community.powerbi.com/t5/Power-Query/This-dataset-includes-a-dynamic-data-source-Since-dynamic-data/m-p/2729076#M84307