When trying to add excel service as Datasource in BI center site, it gives an error “This data source cannot be used because PerformancePoint services is not configured correctly”. To solve the issue, do the steps listed 1. Go to Central admin--> Manage Services --> Secure Store services 2. First time when the secure store services page opens, it says that no keys generated. Click "Generate new key" in toolbar and then step through "targetting" and "set" the key sections 3.Go to "Managed Services" in Central Administration and select the respective PerformancePoint Service 4.Open "PerformancePoint Service Application Settings" and add Unattended Service Account which was configured in step 2 Secure Store Service: - This service application stores the password for the PerformancePoint Services unattended account.
Sharepoint tips and learnings from my day to day work