Tag Archives: SharePoint 2010

Error Creating PerformancePoint datasource


The following error occurs when you attempt to create a new data source using Dashboard Designer 2010:

You do not have sufficient permissions to complete the request

This occurs in the following scenario:

  • Site Collection A contains the following webs:
    • Web1 – root site in site collection
    • Web2 – subweb to Web1 (Business Intelligence Center)
  • You have delegated design permissions to the BI authors in the BI site (Web2). These users do not have permissions on Web1
  • The BI author launches Dashboard Designer from the BI site and attempts to create a data source:


  • When the BI author selects the data source template, the permissions error is displayed.



In the process of creating the data source, Dashboard Designer requires that the user has at least the following permissions in the root web of the site collection:


In my scenario, the BI authors did not need access to the content on the root site, so I simply created a custom permission level on the root with the following permissions:

  • Use Remote Interfaces
  • Use Client Integration Features
  • Open


Once the BI author has these priviledges on the root web, they are able to create PerformancePoint data sources in the BI subweb.


People Picker Field on Datasheet View Empty

When working with a task list in datasheet view, the people picker drop-list should contain the users that are in the site’s user information list.   Occasionally, I have come across the scenario where this list is empty and only shows “(All)”, making the list useless.


  1. To resolve this issue, simply open the list in SharePoint Designer.  Select the list from the Lists and Libraries section. This will display the list settings page in SPD.
  2. Click Edit List Columns
  3. Click the person or group column to display the column editor.  Simply click OK.
  4. Click the Save icon in the title bar of SPD to save the list.
  5. Refresh the datasheet view of the list in SharePoint and now you should have people/groups to select from.