Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
KKirby
Frequent Visitor

Project Online reporting on baseline data

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   

4 REPLIES 4
elijahabule
Frequent Visitor

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

v-chuncz-msft
Community Support
Community Support

@KKirby,

 

You may do research into The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Sam,

 

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

 

Thanks

 

Kelvin

KKirby
Frequent Visitor

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

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors