PerformancePoint error - Cannot connect to data source

Posted on 2010-01-11
Medium Priority
Last Modified: 2012-06-21
We recently installed PerformancePoint on a dev server to try it out. I have Dashboard Designer on my desktop, and SharePoint is installed on a different server. I am trying to create a data source connection to a SharePoint list, and am getting this error:

The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

When I enter the url to the SharePoint site, it populates the drop-down with all the lists on that site, and I can choose the list I want. But if I click "Test Connection," I get the error.

The PPSMonitoringCentral, PPSMonitoringPreview, and PPSMonitoringWebService app pools are all using a domain account for their identity. The domain account has Full Control to the list on SharePoint.

How can I resolve this?
Question by:MercyHousing
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 19

Accepted Solution

MsShadow earned 1000 total points
ID: 26291457
The application pool of your performance point server must run under the same identity as the application pool of SharePoint. That should do the trick.

Author Comment

ID: 26294261
If I change the PerformancePoint application pool identity to match the SharePoint application pool identity, I get this error when trying to connect to PerformancePoint:

Unable to connect to the specified server.  Make sure the address is correct.

I made sure that the domain account is a member of the Admin and Data Source Manager roles on the PerformancePoint server. Currently, the only way I can even connect to the server is to use either the Network Service or the previous domain account identity (which is not the same as the SharePoint identity) for the PerformancePoint application pools.

Author Comment

ID: 26376237
I figured out my mistake - I was attempting to connect to our other SharePoint server, which doesn't have the PerformancePoint components installed yet. Sorry!

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question