Can OData Excel Reports refresh data on browser? RRS feed

  • Question

  • I have Project Server setup and also BI Reporting setup (including Excel Services and Secure Store Service) on my environment. I can open the out-of the-box ODC reports in browser and click refresh data. However, for OData reports, I am getting the following when trying to refresh:

    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:

    If I open the OData reports in Excel client and enable content, I am able to refresh without issue. Is it how it is supposed to work or I need to have Power Pivot (other suggested) install and configure.

    Wednesday, February 17, 2016 6:42 PM

All replies

  • If this is Project Server on premise then the Excel Reports with OData do not refresh in browser.

    Abhijeet, MCTS |

    Thursday, February 18, 2016 12:23 PM