Accessing data in Project Online custom list

[simoncurrier]

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%20Updates/AllItems.aspx.  This list is part of the site temaplate so is created for each new Sharepoint project site, I believe in the same way the OOTB Risks and Issues lists are created.

My question is regaring how I then access the data in Power BI.  I have downloaded the Power BI reporting pack and am customising in Power BI Desktop.  On the "Project Status" report page, I would like to add the latest entry from the "Project Updates" list.  This will then filter depending on the project selected.

I have attempted to update the query to include the list but am unsure how to connect to pull the date in.  I have checked the API (Source = OData.Feed(#"PWA Site URL" & "/_api/ProjectData/[en-us]"),)  however I don't believe custom lists are included.

Any help would be greaty appreciated.

Many thanks

[muneebch041]

I am unable to find the solution, If any one got the solution then please let me know.

[Anonymous]

I have this same issue.  Has this been resolved?  I need to connect to "Project Status Updates" in Power BI desktop and I can't get this to work.

[v-juanli-msft]

Hi @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

[muneebch041]

I didnt find the solution of the query as well here.

[simoncurrier]

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

[hachishti]

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-dynam...