Home > Performance Point > The following data source cannot be used because PerformancePoint Services is not configured correctly.

The following data source cannot be used because PerformancePoint Services is not configured correctly.


If you’re setting up a fresh installation of Performance Point Services 2010 , you might think that all has gone well only to see the above error in Dashboard Designer once you try to start creating scorecards and reports. This is actually quite common – it seems there are a few extra steps to do before you can start using PPS 2010. 


1) Set up the Unattended Service Account. 

Go to the Central Administration page ( on Sharepoint ). Under Application Management , click on Manage Service Applications. Then click on Performance Point Service Application , then Performance Point Service Application Settings. We need to configure the Unattended Execution Account. This is the account that PPS will use to connect to the data source ( unless you use Per User Identity , but thats another story ). If you’ve never seen this page before , there are some interesting options there. Once you set this up and hit Apply. It might be successful, or it might give you another error…. 



2) The Unattended Service Account cannot be set for the service application.
The Secure Store Service key might not have been generated or properly refreshed
after the service was provisioned.

Now I’m not the expert in the Secure Store Service , but Performance Point uses this to store the password for the Unattended execution account. If you get this error, you need to check that a key has been generated for the Secure Store Service. Once again , go to the Central Administration page, and under Application Management , click on Manage Service Applications. Now click on Secure Store Service. Click on Generate New Key. Once that is done, you can go back to set the Unattended Execution Account on the other page , and Dashboard Designer should then work fine. 

 

Advertisements
Categories: Performance Point
  1. Firat
    October 26, 2010 at 3:48 pm

    this is very usefull article. Thanks you Thavash.

  2. ayyappan anbalagan
    October 28, 2010 at 12:39 pm

    Great work man thank a lot

  3. ayyappan anbalagan
    October 28, 2010 at 1:28 pm

    i am getting the same problem while connecting the data base (SQL server) how to solve that issue?

  4. TZ
    December 16, 2010 at 7:39 pm

    This helped! thanks!

  5. Madhu
    February 10, 2011 at 9:05 am

    This is what to say the people are smart and talent. Thanks for sharing man..

    Keep the work forever to learn like me..

    Really thanks for your information.

    madhu

  6. Aditya Agrawal
    April 6, 2011 at 1:07 pm

    hey Thavash

    Your article is very neat and helpful

  7. Ofir
    April 12, 2011 at 3:28 pm

    It’s a good article but still didn’t help me with this problem.
    I can’t generate a key well.
    Does anyone know why i do i get the following error trying to generate a key?
    “Exception of type ‘Microsoft.Office.SecureStoreService.Server.KeyManagement.InvalidMasterKeyException’ was thrown.”

    What phrase should i use??

  8. Sergei
    May 18, 2011 at 5:25 pm

    Hi! You are really time-saver. Thanks a lot.

  9. September 6, 2011 at 5:37 am

    Good times, good info. keep it up

  10. Shital
    December 1, 2011 at 5:08 pm

    Very helpful blog. Thank you very much!

  11. Edward Lee
    December 11, 2011 at 9:44 pm

    Exactly what I needed. Thanks!

  12. Utsav Verma
    October 18, 2012 at 12:14 pm

    Thank you very much! You helped me to create an impression over my boss 😉

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: