Performance Point Service could not connect to the specified data source

One more performance point issue! Previously I have written some articles based on Performance Point Services (PPS) issues and their resolutions, as follows:

http://sharepointknowledgebase.blogspot.com/2013/11/code-blocks-are-not-allowed-in-this.html

http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

http://sharepointknowledgebase.blogspot.com/2013/10/this-data-source-cannot-be-used-because.html

http://sharepointknowledgebase.blogspot.com/2014/04/were-sorry-we-ran-into-problem.html

http://sharepointknowledgebase.blogspot.com/2013/07/cannot-connect-to-performancepoint.html

Note:

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

I have faced the following error while working on PPS and trying to connect SharePoint list via Dashboard Designer.

Error Message:

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

How to reproduce this error?

1.   Open your site in browser

2.   Click on Run Dashboard designer

3.   You will see two options Data connections and PerformancePoint content

4.   Right click on Data connections -> New Data source

5.   Select the data that you are trying to connect (SP list, SQL Server table, analysis services, excel services)

6.   BOOM -> You will get the error at this step!

How to resolve this issue?

Here are the details: [2 step resolution]

Make sure the unattended account has already created. If this is not yet created then please use this link: http://sharepointknowledgebase.blogspot.com/2013/10/unattended-service-account-for.html

Before you start any troubleshooting, please ensure you check your ULS logs as it will give you the exact root cause behind it. When we checked our ULS logs then we found out that “the account needs Read Permission”)

It’s pretty simple once I know the cause. How to check this?

1.   Central administration

2.   Manage web applications

3.   Select the web application which is associated with your site

4.   User Policy

5.   Assign full read permission to unattended service account.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Product applies to:
-SharePoint 2010
-SharePoint 2013

Reference:
http://office.microsoft.com/en-us/dashboard-designer-help/getting-started-performancepoint-dashboard-designer-HA100800792.aspx