locked
Error when excel report refresh RRS feed

  • Question

  • I created an excel report and add it to the sharepoint document library.Whenever I open this excel it shows an error "An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: TfsOlapReport".

    What should I do to avoid this error???

    Monday, September 17, 2012 11:06 AM

All replies

  • Hi Julie,

    Setup the excel services process account from your SharedServices Provider > Excel Services Configuration or set the User Name and Password in your ODC (Office Data Connector). Also, if your using an embedded ODC then you would have to enable the use of embedded permissions. If you have saved the ODC to a SharePoint Library then you need to make its trusted...

    -Ivan


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.

    Wednesday, September 19, 2012 12:20 PM