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.
Product applies to:
-SharePoint 2010
-SharePoint 2013
Reference:
http://office.microsoft.com/en-us/dashboard-designer-help/getting-started-performancepoint-dashboard-designer-HA100800792.aspx
No comments:
Post a Comment