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: