#Microsoft #Project – the future #Ignite #PPM #PMOT #Workmanagement #ProjectOnline #ProjectManagement

September 24, 2018 at 9:18 pm | Posted in Administration, Configuration, Functionality, Information | 3 Comments
Tags: , , , ,

From the session today for Project Online, 3 key points:


All project work management experiences from the Project Home that was recently released – this is now live: https://pwmather.wordpress.com/2018/08/20/new-projectonline-project-home-office365-ppm-ui-ux-msproject-fabricui/

From the Project Home you will be able to create different project artefacts, such as a Roadmap (see below) or a new project.

New feature for Project is the Roadmap product – first release early 2019 calendar year, a visual tool that lets you visualise projects on a timeline view with a row per project. On each row you can display tasks from each project added to the Roadmap. This will allow you to see projects from Project Online, Azure Boards, Planner, the new Project Service (see below) etc. Security backed by modern Office 365 groups. Connections to these projects are based on Microsoft Flow, data synchronised using Microsoft Flow. Some screenshots below:



Another new feature is the new Project Service – first release during 2019, this is not Project Online but a new Project product written from the group up. This has a lot of focus on being a modern UI with a great user experience, being simple to use yet powerful. Under the covers all of the great scheduling features are there, it’s a revamped scheduling engine that is used today in Project Online – but re-engineered to be scalable and optimised. Lots of changes such as no need to build team anymore, you can just type user names from the organisation into a people picker, these are added into the resource pool.

Screenshot of resourcing:


Co-authoring possible in the new project and no check in check or save / publishing actions required.

The new Project Service will make use of the Universal Resource Scheduling service to enable better resourcing across the organisation, here is a Dynamics 365 link to this service: https://blogs.msdn.microsoft.com/crm/2018/05/07/whats-new-in-universal-resource-scheduling-for-dynamics-365-may-2018-update/

Project Desktop is still a first class citizen in the new Project if project managers wanted to continue using the Project Desktop tool.

New Project feature is built on the Power Platform backed by the CDS which means making use of Microsoft Flow and Power Apps very simple! Power Apps for Project Online is something I spoke about at the Project Virtual Conference: https://pwmather.wordpress.com/2018/06/14/getting-starting-with-projectonline-and-powerapps-pvc18-presentation-links-ppm-pmot-apps-office365-msproject/ – this becomes very simple and a lot more powerful in the new Project service! The same goes for Microsoft Flow: https://pwmather.wordpress.com/tag/flow/  – the potential and power to build awesome apps for Project will be very simple!

All new services for Project (Roadmap, new Project Service etc.) are built on the Common Data Service for apps. Details on the CDS can be found here: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro

Modern Work management eco system:


Microsoft’s Work Management vision:


Project Online will continue to get security and performance improvements.

Organisations will be able to run both Project Online and the new Project Service side by side and pull data in to a Roadmap from both. There will be some form of migration from Project Online to the new Project Service but details are still to be confirmed.

Exciting times ahead for the Microsoft Project space!

Security trim Project data in #ProjectOnline #PowerBI #Excel #PowerQuery reports part 2 #PPM #Odata #REST #BI

December 12, 2016 at 5:46 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Reporting | 1 Comment
Tags: , , , , , , ,

Further to my last post on an example method to security trim the Project data in a Power BI report for Microsoft’s Project Online PPM tool, another option is to merge the datasets / tables. If you didn’t see the first post, a link can be found below:


For this post, I have the same two ODATA / REST queries used, the ODATA one for the Milestones (/_api/ProjectData/Tasks()?$Filter=TaskIsMilestone eq true) which is not security trimmed and the REST one for the Projects (/_api/ProjectServer/Projects) which is security trimmed. With both of these datasets loaded into the Power BI Query Editor, select the Milestone dataset and click Merge from the Home ribbon tab and set the following:


This is merging my two tables based on ProjectId from the Milestone dataset and Id from the Projects dataset using a Left Outer join. You can see from that screen shot that I don’t actually have access to the Agile Product Development project in PWA as it is not returned in the list of projects in the REST dataset. Clicking OK will show a NewColumn:


Click expand and select Name:


That returns nulls for the project names you do not have access to:


These rows should be filtered out, click the Name column heading dropdown and de-select null:


Click OK and the Milestone dataset table will match the list of projects you have access to in PWA – the rows with nulls in the Name column will be removed from the table. I then renamed the Milestones – ODATA dataset to Filtered Milestones:


Click Close & Apply then the load a couple of visualisations on to the report and you can see that now the data is security trimmed as part of the query and not in the report:


In this simple example there is no need for the report level filter to remove the nulls at the report level like there was in the previous post. The same applies as with the previous post, if your users know Power BI  / Power Query they can easily undo all of this and access all the data but this might be an option to explore.

Security trim Project data in #ProjectOnline #PowerBI reports #PPM #Odata #REST #BI

December 9, 2016 at 1:29 pm | Posted in Add-on, Administration, Configuration, Customisation, Functionality, Information, Reporting | 5 Comments
Tags: , , , , , , ,

The reporting API for Microsoft’s PPM solution – Project Online doesn’t filter the data based on the access model in PWA. For some organisations this can be problematic. In this blog post I show a simple report example to filter only projects and project milestones that I have access to in PWA.

In this example I have a very simple Power BI Report that is only using ODATA (_api/ProjectData), the Projects resource path to populate the Projects slicer / filter and the Tasks resource path to populate the Milestones for the selected Project:


I have access to a long list of projects (see the scroll bar on the slicer). Using the Audit Tracking project as an example, I can currently see this project in PWA as shown below:


I will change the access model so I get access denied to this project:


I only see these 6 projects projects in an unfiltered Project Center view:


Yet if I refresh my Power BI report I still see the full list as expected (the ODATA reporting API is not data security trimmed, you either access all data or none). One option is to use the REST (_api/ProjectServer) to filter the datasets that use the ODATA API as the source. The REST API is security trimmed to only show the data you have access to based on the access model in PWA. For example, I will get the list of Projects from REST to populate the Projects slicer / filter in Power BI, this only shows the projects I have access to in PWA. I have added a new data source to my simple Power BI report for the REST API:


The join is then set up on Id from the Projects REST dataset to the ProjectId in the Milestones OData dataset:


I now switch my slicer / filter to use the Projects – REST dataset


As you can see the list of projects matches what I see in the Project Center but there is a also a blank option there. The blank value is for rows it can’t join with on the Milestone ODATA dataset, these are the projects I no longer have permission to access in PWA! To resolve this, select the page and add a report level filter like below where Name is not blank:


This report filter will not show any blank values for the Name field on any visualisation in the report:


The blank value is now removed. My data is now security trimmed to match what I have access to in PWA! Obviously if you know what you are doing you can just undo all of this and see all data but for some it might be a workable solution! You can do the same with Resources too.

#Microsoft #Office365 Planner – #Task Management Tool #PMO #PMOT

September 23, 2015 at 8:49 am | Posted in Information | 1 Comment
Tags: , ,

A quick post to highlight a new tool that is going to be released soon called Office 365 Planner. This tool is great for organising team work with projects, tasks, assignments, documents in a visual way. For more details and screen shots see the link below:


New Milestone Gantt #App for #ProjectOnline & #ProjectServer #PS2013 #Office365 #Project #PMO #BI

October 11, 2014 at 8:16 pm | Posted in Add-on, Administration, App, Customisation, Functionality, Information, Installation, Reporting | Comments Off on New Milestone Gantt #App for #ProjectOnline & #ProjectServer #PS2013 #Office365 #Project #PMO #BI
Tags: , , , , , ,

CPS’ 4th SharePoint hosted app has been released into the App store. The app is called the “Milestone Gantt” app. The app can be downloaded here:


This app displays project milestones on a Gantt style chart, see the screen shots below:





The app has configuration options to enable the Project Web App administrators to configure the settings to meet the organisations requirements.

For more details see the user guide here.

For more CPS apps see the link below:


CPS’ #Office #Project Task Auditor #App wins first place at #SPC14 App #Awards #SharePoint

March 4, 2014 at 1:15 pm | Posted in Add-on, Administration, App, Functionality, Information | 2 Comments
Tags: , , , , ,

The Task Auditor app from CPS won first place for the “Most Business Value Project” App at the SharePoint Conference 2014 in Las Vegas:


This is a free Project task pane app, go try it out and see what you think Smile

See the links below for details:

App store: http://office.microsoft.com/en-gb/store/task-auditor-WA104172076.aspx

Product site: http://www.projectserverplus.com/apps.html 

Blog post: https://pwmather.wordpress.com/2013/12/12/free-project-2013-app-from-cps-office365-office-apps-projectserver-projectonline/

#Microsoft Community Contributor Award 2011 – Thanks

August 31, 2011 at 2:57 pm | Posted in Personal | Comments Off on #Microsoft Community Contributor Award 2011 – Thanks

Just a quick post today, I am pleased to announce that yesterday I was awarded with the Microsoft Community Contributor Award 2011.

Create a free website or blog at WordPress.com.
Entries and comments feeds.