A Blog about SharePoint knowledge. Here you can find most information related to SharePoint Administration, SharePoint Development, My experience with SharePoint client, Information on SharePoint server and End user computing, SharePoint Study Materials etc. HAPPY Reading...!
Performance Point Service could not connect to the specified data source
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)
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?
2.Manage web applications
3.Select the web application which is associated with your site
5.Assign full read permission to unattended service account.
Product applies to: -SharePoint 2010 -SharePoint 2013