none
Refresh of Odata reports in the browser on premise RRS feed

  • Question

  • Hi,

    I have a question about Odata refresh in the broswer. Is there support for on premise refresh of Odata reports in the browser connecting to http://ServerName/ProjectServerName/_api/ProjectData? About a year ago as I understood it the answer was no, has this changed with any service pack or other update? 

    Best regards

    Johan
    Friday, May 23, 2014 3:12 PM

Answers

  • Ok I understand. Once the reports are created and published to Excel Services, end users don't need direct access to the database, it is all handled by Excel Services SSO and the secure store. If you really do need to stick with ODATA you won't be able to refresh these in the web on prem, only via the Excel client. One option would be to write a script (Powershell etc.) to open the Excel work book, refresh the ODATA data sources then save the workbook back to the SharePoint library. You could schedule this on a nightly basis using the windows task scheduler. Paul

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

    Monday, May 26, 2014 1:31 PM
    Moderator

All replies

  • I remember they enabled the refresh feature in project online but haven't heard anything about it being available for on premise yet hence no confirmation about that yet, but given that Project Server Known issues document has not been updated yet, i would assume there is still problem with oData refresh

    Thanks | epmXperts | http://epmxperts.wordpress.com

    Friday, May 23, 2014 3:38 PM
    Moderator
  • Thanks for your answer. If manual refresh of Odata reports for Project Server in the browser does not work on premise, I guess this also means that there is no easy possibility to schedule refresh of Odata reports on premise either, or is it? To have the Odata reports refresh by a schedule once a day would be sufficient for our customer.

    Best regards

    Johan

    Monday, May 26, 2014 10:35 AM
  • Hello. Why use ODATA when on prem? I would always use direct access the the SQL reporting tables or views. These give greater flexibility and will also refresh in Excel Services. Paul

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

    Monday, May 26, 2014 11:20 AM
    Moderator
  • Hi

    The customer does not allow direct access for users to the database for security reasons. Hence Odata is the only possibility.

    Best regards

    Johan

    Monday, May 26, 2014 12:48 PM
  • Ok I understand. Once the reports are created and published to Excel Services, end users don't need direct access to the database, it is all handled by Excel Services SSO and the secure store. If you really do need to stick with ODATA you won't be able to refresh these in the web on prem, only via the Excel client. One option would be to write a script (Powershell etc.) to open the Excel work book, refresh the ODATA data sources then save the workbook back to the SharePoint library. You could schedule this on a nightly basis using the windows task scheduler. Paul

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

    Monday, May 26, 2014 1:31 PM
    Moderator
  • Thanks for your answer Paul. This is what we expected. Let's hope there will some update comming to be able to refresh Odata in the browser on premise. But for now we have to use alternative ways.

    Best regards

    Johan

    Monday, May 26, 2014 3:09 PM
  • Hello,

    I'm not sure it will come anytime soon as I think the current thinking is that most organisations will just either use the OLAP cube or direct SQL queries. Similarly, you will find bugs in the On-prem ODATA feeds that have been resolved in Project Online but not Project Server on-prem, I guess the same logic applies in the fact that people wont use ODATA on-prem. The only issue I see with this is if you are building apps that use ODATA, you need to parity between on-prem and online.

    Paul


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

    Monday, May 26, 2014 7:02 PM
    Moderator