09 April, 2014

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:






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

4 comments:

  1. This is great! I am hoping to use this on a mass scale to help with tasks for my job.Thanks for sharing !

    ReplyDelete
  2. I want know some helpful things from this side. It is one of the best post from other. It is a useful and charming post.It is extremely helpful for me.

    Linux Thin Client & Citrix Thin Client

    ReplyDelete
  3. Thanks for the solution. This was very helpful.

    ReplyDelete
  4. i have followed the same steps as your instructions by granting the Unattended account full read but still getting the same error

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge