Wednesday, June 24, 2015

This workbook contains external data connections or BI features that are not supported #projectonline

Just came across the joys of "enable/disable preview features" in office 365 SharePoint Admin.

My users were reporting that they were unable to refresh published Project Online reports in their browser.  They received the following message:

                      This workbook contains external data connections or BI features that are not supported.

The issue was caused by a setting in the SharePoint Online Admin Portal (Admin | SharePoint | Settings).  

Selecting Enable Preview Features (see below) allows users to refresh Project Online Reports using oData feeds in their browser.  

As a reminder, the following two elements also need enabling if you haven't done so already:


user group permissions:


Site collection features: 

Monday, June 15, 2015

TPG Apps Highlights - Risk Matrix #projectonline #projectserver #risk

This post is the first of a series to highlight the apps available for Project Server and Project Online from the SharePoint store  (https://store.office.com/search.aspx?productgroup=SharePoint&qu=tpg) and direct via your local TPG office.

The first of this series will look at the simple plug-and-play apps that all users of Project Online can make use of quickly and easily.  These are:
  • Risk Matrix 
  • Milestone Trend Analysis (MTA)
  • WBS Chart viewer

Next we will focus on the challenge of Resource Request Supply and Demand by demonstrating our more recent TeamLink and TeamManager apps.
  • Team Manager App is a Resource Manager/Owner app for allocating resource supply to Projects and BAU activities and monitoring demands against commitments
  • Team Link App is a PM tool for monitoring Project demands vs the supply provided by the Resource Managers 

Finally I will highlight some of the benefits of our integration tools when used in the context of Project Online
  • ResourceLink for the synchronisation of resources, custom fields and custom field values between your on-premise data sources and Project Online.
  • PSLink for transactional input/outputs from your on-premise data to Project Online 


So... here is part one of (many)....

Risk Matrix

TPG's Risk Matrix provides a quick and simple mechanism for aggregating and displaying project risks in a 5x5 matrix.

The app can be embedded either on a Project PDP, a Project Site Page or Homepage, or even viewed as a site level app where you can manually select the Project to interrogate (see below for screenshots).

 PDP embedded


PWA Site-level project selection

PWA Site-level project display

Project Site-level embedded on homepage.

Thursday, June 4, 2015

Project Online "upgrade" #projectonline #iconmadness

Looks like the peeps over in Redmond have been busy making some changes to the Project Online UI

I get the feeling they're not quite finished yet as the icons have gone crazy!!