locked
Excel Workbook in PDP Webpart RRS feed

  • Question

  • hello,

    I created a simple excel that loads data from /pwa/_api/ProjectData (OData Feed), then uploaded the document to project server, and added it to an Excel web part. The problem is when I open the PDP, an error refreshing the data occur (in Excel it works fine) : "External Data refresh Failed, We cannot locate a server to load the workbook Data Model". I also added the workbook to trusted excel services locations. What can be the problem?

    Tuesday, November 4, 2014 10:31 AM

Answers

All replies

  • Hello,

    If this is on Project Online you will need to enable the Excel Web App refresh feature: 

    http://office.microsoft.com/en-gb/office365-project-online-help/grant-reporting-access-in-project-online-HA104021109.aspx

    If using Project Server 2013 on-prem - the ODATA reports don't refresh in the Excel Web App - I'd recommend using the PWA database Reporting schema (dbo.) as the data source as the Excel based reports will refresh in the Excel Services if the reporting / access / secure store is configured correctly.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Marked as answer by hassane101 Wednesday, November 5, 2014 7:01 AM
    Tuesday, November 4, 2014 11:25 AM
  • Thank you for the suggestions

    It's on prem implementation. But Why the OData reports don't refresh in Excel Web App?

    The PWA DB works fine as source, but the OData has simpler tables for simple reports.  They work fine for sharepoint lists. Any workarounds?

    Tuesday, November 4, 2014 7:51 PM
  • The ProjectData (OData) API was designed to overcome the reporting issues with Project Online, on-prem using Project Server you have full access to the OLAP Cube or PWA Database (Reporting schema). With this in mind, only the Excel Reports using the OLAP Cube or SQL will refresh in Excel Services. Take a look at the OLAP cube, this will give a similar end user experience to ODATA in terms of creating reports.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, November 4, 2014 7:59 PM