locked
Excel Web Access Web Part RRS feed

  • Question

  • Hi,

    I am using Excel Web Access Web Part for showing reports in Project Server 2013.

    I have large data behind excel (using SQL Query), I have set the data is refresh in query window when file is opened (or I can set manually refresh data when select "Refresh Data Connection" from web).

    I want the Data is refreshed once in a day in Off peak time so that the report load is minimized when every time the report is opened. How can I do that?

    Regards,


    Noman Sohail


    • Edited by NomanSohail Tuesday, November 8, 2016 6:12 AM Update
    Tuesday, November 8, 2016 6:12 AM

Answers

  • Hello,

    There is nothing out of the box for Project Server 2013 that does a scheduled refresh of the Excel based reports. This is standard capability in Power BI though (if you used Project Online). For On-prem you might be able to use a PowerShell script to open the Excel workbook, update the data and save it back to the library on a windows scheduled task?

    Paul


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

    • Marked as answer by PWMatherMVP Tuesday, February 28, 2017 10:49 PM
    Tuesday, November 8, 2016 4:40 PM