Home > Visual Studio > TFS 2010 + Sharepoint 2010 – Errors when showing reports in Dashboard

TFS 2010 + Sharepoint 2010 – Errors when showing reports in Dashboard

Out of the box, should you try to view the TFS reports in SP2010, you will encounter 2 errors

1. Warning from Excel Services

This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions.

If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook.

Do you want to enable queries to external data in this workbook?

To fix this:

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Service Applications page, click Excel Services Application.
  3. On the Manage Excel Services Application page, click Trusted File Locations.
  4. On the Excel Services Application Trusted File Locations page, point to the trusted file location that you want to edit (e.g. http://), click the arrow that appears, and then click Edit.
  5. On the Excel Services Application Edit Trusted File Location page, in the External Data section, clear the Refresh warning enabled checkbox, and then click OK.

2. Error at Excel Report

The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh:

TfsOlapReport

To fix this:

  1. On the Team Foundation Server Administration Console, click on the TFS server in question
  2. Click Extensions for Sharepoint Products
  3. Select the Sharepoint Web Application which you are using
  4. Click Modify Access
  5. Enter a user with access rights to the reports inside the Enterprise Application Definition field
  6. Click OK

Useful URLS:

http://blogs.msdn.com/b/granth/archive/2009/12/03/tfs2010-troubleshooting-sharepoint-dashboards-data-source-problems.aspx

http://msdn.microsoft.com/en-us/library/ee462863(VS.100).aspx

Advertisements
Categories: Visual Studio
  1. Paul
    December 13, 2011 at 11:33 pm

    There is no menu for “Extensions for Sharepoint Products” in my console.

    • December 14, 2011 at 4:21 pm

      Hi Paul,

      May i know which version of sharepoint you are using?

    • sguitardude
      November 10, 2012 at 5:51 am

      I did not see “Extensions for SharePoint Products” on my TFS Server, it was on my SharePoint Server.

  2. September 14, 2012 at 11:15 pm

    This came in handy today, thanks.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: