topic Re: Project Online reporting on baseline data in Developer

Project Online reporting on baseline data

KKirby — Fri, 06 Apr 2018 09:42:54 GMT

Hello,

I am trying to expose Project Online Baseline data in a report in PowerBI. Whilst I can connect to the odata feed at https://contoso.sharepoint.com/sites/pwa/_api/ProjectData/ProjectBaselines, this only seems to display the main baseline data. I need to also show Baseline1 Work, Baseline1 Cost, Baseline2 Work, Baseline2 Cost, etc, however I can't seem to figure out how to get this data. I'm probably missing something obvious but I can't see it!!

I was really hoping to modiify a version of the reports in the Project Online Content Pack (latest) to show this as an additional report.

Any help would be appreciated.

Thanks

Kelvin

Re: Project Online reporting on baseline data

v-chuncz-msft — Mon, 09 Apr 2018 06:54:36 GMT

@KKirby,

You may do research into The Advanced Editor.

Re: Project Online reporting on baseline data

KKirby — Mon, 09 Apr 2018 07:04:27 GMT

Hi Sam,

Many Thanks - I will look into this further.....

Thanks

Kelvin

Re: Project Online reporting on baseline data

KKirby — Mon, 09 Apr 2018 11:12:42 GMT

Hi Sam,

I looked at the Advanced Editor but this only shows the syntax of the query. It doesn't show me where to find the Baseline1 Work, Baseline1 Cost, etc fields. What I am looking for is the actual data source where these might reside in Microsoft Project Online. Any ideas on the data source that might host these fields ?

Thanks

Kelvin

Re: Project Online reporting on baseline data

elijahabule — Fri, 24 Aug 2018 11:30:19 GMT

Hello i have the same issue. Couldnt find datasource for other baseline info (Baseline 1 , Baseline 2 ) other than the default baseline.