locked
Project Server 2013 EXCEl OData Reporting RRS feed

  • Question

  • Hi All,

    I have one Powerpivot Excel report which is uploaded in One share point site library.

    Whenever I open the report in the browser and click the refresh button,the data is not updated properly some fields data is getting missed.But whenever I open the reports 'Open in excel'(outside of browser in server connection mode)data is refreshing and reflecting completely. 

    Now I would like to know why the data is not reflecting after refreshing in browser.Kindly help.

    Thanks in advance


    Soumya T | EPM Consultant

    Wednesday, October 26, 2016 9:46 AM

Answers

  • Soumya

    Odata reports can't be refreshed in Excel 2010

    Only 2013 onwards is supported


    Hrishi

    • Marked as answer by Soumya.T Thursday, November 3, 2016 10:00 AM
    Thursday, October 27, 2016 11:03 PM

All replies

  • Hi Soumya,

    I would suggest you to select 'Refresh all connections'. Hope you are not refreshing "Refresh selected connection".

    You should not have any permissions issue when refreshing the connection because you are already able to access the reports.

    Also, download a copy of the excel report and select the connections and update the connection properties and upload it back to the reports folder.

    let me know it helps.

    Regards,

    Sudhir

    Wednesday, October 26, 2016 10:57 AM
  • Hi Sudhir,

    Thanks for the reply firstly.

    I am not getting the "Refresh this connection on refresh All" check box in Excel

    Kindly help me on this.

    Thank you

    


    Soumya T | EPM Consultant

    Wednesday, October 26, 2016 12:09 PM
  • Soumya, In which excel version have you saved the report. Are you editing it from excel 2013? I use excel 2013. Regards, Sudhir
    Wednesday, October 26, 2016 4:25 PM
  • Hi Sudhir,

    I am using excel 2010.Do you have any idea about how to solve for this case in excel 2010.Please let me know


    Soumya T | EPM Consultant

    Thursday, October 27, 2016 4:35 AM
  • Soumya

    Odata reports can't be refreshed in Excel 2010

    Only 2013 onwards is supported


    Hrishi

    • Marked as answer by Soumya.T Thursday, November 3, 2016 10:00 AM
    Thursday, October 27, 2016 11:03 PM
  • Hrishi,

    Thank your for your reply.



    Soumya T | EPM Consultant

    Thursday, November 3, 2016 9:59 AM