I was trying to connect to a sharepoint list in PPS designer 2010 and SharePoint 2010 and i’m getting this error:
I checked the eventlog and i found the following error:
The following data source cannot be used because PerformancePoint Services is not configured correctly.
Data source location: http://PORTAL/BI/Data Connections for PerformancePoint/1_.000
Data source name: New Data Source
The PerformancePoint Services Unattended Service Account is not set. The setting is located in “Manage service applications” in SharePoint Central Administration under the PerformancePoint Services management page.
I opened the central administration – > Application management and select manage service applications.
Select performance point services application and click on pps application settings link and try to set the secure store service (sss). set username and password and hit ok.
You might get this error message:
The Microsoft Secure Store Service application Secure Store Service failed to retrieve the master secret key. The error returned was: ‘Unable to obtain master key.’. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).
To fix it, go to the manage service applications and select secure store service and click on generate new key and ok.
Go back to the PPS and set the username/password PPS service account.
Hope this helps, happy sharepointing 2010 !!!