locked
Project Server 2013 Default Pivot Excel report RRS feed

  • Question

  • Hi All,

    We have configured the default excel report available in the BI Center. When we open the project overview report and select the project names we are getting the below error. But when we open the report in excel it is working fine. I have followed the steps in the below post, but still same issue.

    http://blogs.technet.com/b/excel_services__powerpivot_for_sharepoint_support_blog/archive/2013/01/31/powerpivot-for-sharepoint-browser-refresh-fails-data-refresh-not-supported-in-office-web-apps.aspx

     


    Thanks in advance, Taj


    • Edited by arun_2014 Saturday, May 31, 2014 9:31 PM
    Saturday, May 31, 2014 9:30 PM

Answers

  • Hello. The ODATA reports will not refresh / update in Excel Services when using Project Server on-premise, open these in Excel client to update. ODATA reports will refresh in Excel Services in Project Online (office 365). If on-premise, use either the OLAP cube or the Reporting schema database tables / views as the data source in the Excel reports if you these to be refreshable in the web. Paul

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

    • Marked as answer by PWMatherMVP Wednesday, July 16, 2014 10:34 AM
    Sunday, June 1, 2014 2:36 AM

All replies