none
Unable refresh Excel reports on Project online RRS feed

  • Question

  • Hi All,

    I have created an excel report using OData feed, Im able refresh it in Excel desktop Application but in excel online.
    I have activated the "Project Web App Permission for Excel Web App Refresh" feature. but still Im not able to refresh any report including default MS reports(Project Overview Dashboard and Resource OverView).

    Below is the Error when I refresh the report: 

    External Data Refresh Failed

    An error occurred while working on the Data Model in the workbook. Please try again. 

    We were unable to refresh one or more data connections in this workbook. 
    The following connections failed to refresh:

    Can anyone please let me know what needs to be done to get work the excel report refresh functionality?

    Thanks in Advance.. 

    Wednesday, April 20, 2016 12:35 PM

Answers

  • Hi Rajkumar,

    Have you checked this blog post about enabling Excel odata Refresh in IE?

    https://blogs.office.com/2013/03/29/project-online-and-excel-web-app-cloud-data-improves-reporting/#13OMqXILr04A0Jjm.97


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, MCC |

    Wednesday, April 20, 2016 1:34 PM
    Moderator

All replies

  • Hi Rajkumar,

    Have you checked this blog post about enabling Excel odata Refresh in IE?

    https://blogs.office.com/2013/03/29/project-online-and-excel-web-app-cloud-data-improves-reporting/#13OMqXILr04A0Jjm.97


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, MCC |

    Wednesday, April 20, 2016 1:34 PM
    Moderator
  • Hi Guillaume,

    Thanks for reply to my query. I haven't done the above you have mentioned. If I do the above will it resolve my issue? If I'm not wrong Only tenant Admin can do the above process right?

    Wednesday, April 20, 2016 2:29 PM
  • I'm able to refresh Excel reports now by grating permission to the Azure BI, added it as a trusted app as specified in the  link.

    https://blogs.office.com/2013/03/29/project-online-and-excel-web-app-cloud-data-improves-reporting/#13OMqXILr04A0Jjm.97


    Friday, April 29, 2016 10:17 AM