Home > SharePoint 2010 > BI Center and Data Connection Errors When Using PerformancePoint Dashboard Designer

BI Center and Data Connection Errors When Using PerformancePoint Dashboard Designer

A common way to display your BI assets in SharePoint 2010 is to use a site template called Business Intelligence Center. The Business Intelligence Center (a.k.a BI Center) is the enhanced version of the Report Center in MOSS 2007. The site template includes many of the BI capabilities that Microsoft has introduced in SharePoint Server 2010 all packaged into a single site. Although using Business Intelligence Center is not the only way to access SharePoint’s BI features,this site template can provide a central location for teams and departments within your organization to store, retrieve, and modify shared reports, dashboards, Excel workbooks and etc.

Recently, I have been busy creating and migrating some PerformancePoint dashboards to SharePoint 2010. During the migration process, I came across a couple of weird errors in the Dashboard Designer which I thought to highlight in this blog post:

Error #1) You lunch the Dashboard Designer Click-Once application and try to create a new data connection,and then you get the following error:

“The item no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator”

Windows Event Viewer Log Entry: Microsoft.PerformancePoint.Scorecards.BpmException: The item ‘http://splab/BICenter/Data Connections for PerformancePoint/AdventureWorksDW_ADCube.odc’ is not a valid PerformancePoint Data Source. Check to make sure the content type of this item is correct. at Microsoft.PerformancePoint.Scorecards.Store.Dao.DataSourceSPDao.ValidateFile(SPListItem item) at Microsoft.PerformancePoint.Scorecards.Store.Dao.SPDocDao.Get(ISPFcoCache cache, Guid webSiteID, RepositoryLocation location, SPListItem item)

Cause:It turned out that prior to launching the Dashboard Designer, I had uploaded an Excel Workbook to the BI Center and the Workbook’s data connection file was added using the PerformancPoint Data Source content type. This is a normal behavior, because PerformancPoint Data Source content type is the default content type in the library. Unless you explicitly specify which content type to assign to your data connection file,the default content type will be picked up and assigned to an uploaded file. So, when Dashboard Designer is lunched from within the BI Center , first, it attempts to resolve this data connection (AdventureWorksDW_ADCube), which is obviously not a valid PerformancePoint data connection, but an *.odc file used in a published Excel Workbook.

Resolution: Edit the data connection file and assign the right content type to it, as in my case it was : Office Data Connection File.

Error #2) You launch the Dashboard Designer Click-Once application and create a new data connection.

When you specify the name of the server and after you select the database to connect to, you get the following error:

“The query could not complete because the data source “New Data Source” is not in a PerformancePoint trusted location”

Windows Event Viewer Log Entry: The query could not complete because the following items are not in a PerformancePoint trusted location: New Data Source The shared service administrator must configure the following content locations as “trusted”: The shared service administrator must configure the following data source locations as “trusted”: /BICenter/Data Connections for PerformancePoint Trusted Locations can be configured for the PerformancePoint Service Application by using PowerShell Cmdlets or through SharePoint Central Administration. PerformancePoint Services error code 22002.

Cause: The Data Connection Library in the BI Center is not added to PerformancePoint trusted locations by default.

Resolution: As indicated by the Windows log entry,you need to add the URL of the Data Connection Library to the list of trusted locations.See this page for more information.

Error #3) You launch the Dashboard Designer Click-Once application and attempt to connect to a database , but no database shows up in the Database drop-down list.

You switch to the “Use the following connection” option and you specify the following connection string:

[Xml]
Provider=MSOLAP.4;Integrated Security=SSPI;
Persist Security Info=True;Initial Catalog=
Adventure Works DW 2008R2;Data Source=.;
MDX Compatibility=1;Safety Options=2;
MDX Missing Member Mode=Error
[/Xml]

And you get the following error:

The Unattended Service Account “” does not have permissions to see this data. Additional details have been logged for your computer.

Windows Event Viewer Log Entry:Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, CONTOSO\ppfunattensvc, does not have access to the Adventure Works DW 2008R2 database, or the database does not exist.

Cause: PerformancePoint Unattended service account has permission to connect to the database.

Resolution: Ensure that the PerformancePoint unattended service account has permission to the SQL Server instance where the database exists or the database itself.Once the permissions are granted, the database should show up just fine in the list of available databases.

Last but certainly not least, if you are connecting up to a SSAS cube, you need to make sure the PerformancePoint unattended service has access to the cube and the underlying data warehouse.

Categories: SharePoint 2010 Tags:
  1. May 6th, 2010 at 00:46 | #1

    Resolution for Error#1 is not working for me. I have clean Sharepoint 2010 installation on 64 bit clean workstation. Permissions defined as follows:
    Approvers
    SharePoint Group Full Control
    BI Members
    SharePoint Group Full Control
    BI Owners
    SharePoint Group Full Control
    BI Visitors
    SharePoint Group Full Control
    Designers
    SharePoint Group Full Control, Limited Access
    Hierarchy Managers
    SharePoint Group Full Control
    Restricted Readers
    SharePoint Group Full Control
    System Account (SHAREPOINT\system)
    User Full Control, Limited Access
    Viewers
    SharePoint Group Full Control
    WIN-QUDE7JJOLKO\Administrator (WIN-QUDE7JJOLKO\administrator)
    User Full Control

    Any ideas?

  2. Reza Alirezaei
    May 6th, 2010 at 07:37 | #3

    @Dmitri

    Resolution to which error is applying this hotfix?

  3. May 9th, 2010 at 18:43 | #4

    Error #1 – “The item no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator”

  4. Lynne Roberts
    September 22nd, 2010 at 12:19 | #5

    This may be a simple question, but how do you grant permission to view a cube. I can create a SQL connection and view the databases and the tables, but when I do a SASS connection not databases are listed. Can you help?

  5. Brock
    October 8th, 2010 at 20:18 | #6

    Dimitri -
    For this error “The item no longer exists or you do not have permissions to view it. Additional details have been logged for your administrator”

    Grant the service account you are using for PerformancePoint VISITOR rights. The service account needs access to read the data connection file – many people run as the Portal Pool account so they don’t have this issue. We ran into it since we aren’t using the Portal Pool for all services.

    Brock

  6. Liesl Andrico
    January 19th, 2011 at 16:17 | #7

    Does anyone have a problem with the fact that database access is granted wtih one unattended service account for anyone who is creating Performance Point Dashboards? There seems to be no way to limit access to a database once someone knows the unattended service account name and database information – they can gain access if they are a designer on a sharepoint site.

    I am interested to know if other companies have issues with this security model, or how they have worked around it.

    Thanks,

    Liesl Andrico
    SharePoint BI product Owner
    Intel

  7. Abhishek
    April 4th, 2012 at 15:23 | #8

    Thanks Brock ….. this actually worked…….. thanks for the great help

  1. No trackbacks yet.