LAUNCHED - OData Improvements to Include Timestamps for Project Entities

Last year, I was excited about a roadmap feature that had been updated on the Office 365 Roadmap. I talked about it here.

Well, here is an even more exciting update as it has been released the 4th of January. I haven't seen any official blogs yet so I had a bit of an investigation to understand what changed.

Overall, Microsoft has kindly provided the modified information to the following tables;

DataSet	Added Field	Comment
Assignment Baseline Timephased	AssignmentBaselineModifiedDate	Date of the modified baseline (date it has been published)
Assignment Timephased	AssignmentModifiedDate	Date the Assignment has been last modified
Engagement Timephased	EngagementModifiedDate	Date the Engagement has been last modified
Engagements	EngagementModifiedDate	Date the Engagement has been last modified
Project Baselines	ProjectBaselineModifiedDate	Publish date of the last modified baselines
Resource Demand Timephased	ResourceDemandModifiedDate	Date of the Resource Demande last modified
Resource Timephased	ResourceModifiedDate	Date of the Resource last modified
Task Baselines	TaskBaselineModifiedDate	Date of the modified baseline (date it has been published)
Task Baselines Timephased	TaskBaselineModifiedDate	Date of the modified baseline (date it has been published)
Task Timephased	TaskModifiedDate	Date of the task last modified
TimesheetLine Actual	TimesheetLineModifiedDate	Date of the timesheet line last modified

That is really great addition. For example, as Guillaume was stating in his comment from the previous blog, we can now track changes in the baselines and validate when a baseline has been defined.
Therefore, we can easily add a bit of smart in the queries to download only if a data has been modified.

Here is a quick example of a Power Bi report using the Baseline Modification Data to highlight tasks baselined after the project has been baselined.

One thing I am not so happy about is that I was expecting to have a trending capability with some historical data stored somewhere. I guess I was too demanding. The new fields are providing with a last modified date at a lower level than the Project level but are not recording the historical values of the fields before they changed. Something that Microsoft is hopefully considering soon. you can vote here: https://microsoftproject.uservoice.com/forums/218133-microsoft-project/suggestions/15300603-implement-versioning-in-project-online.

Tell me what you think about that added information and what usage you may do of it!