locked
Project Server 2013 EXCEl OData Reporting RRS feed

 , 
 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hrishi,

    Thank your for your reply.


    Soumya T | EPM Consultant

    Thursday, November 3, 2016 9:59 AM