SQL Centre of Excellence

I’ve been having a few problems with the following error message in Dashboard Designer 2010, when refreshing a data connection to SSAS.

“The following lists cannot be accessed from SharePoint server. The lists have been deleted or you no longer have permission to open them. “

image

There was also a note in the application log “Failed to Read the ACLS for an item”

image

The crux of the problem is that Application pool for PerformancePoint is used to invoke SharePoint web services, and it needs at least “Read” access on the data connections folder. You can right click on the data connections library in Dashboard Designer and select “Edit Permissions”. Note that the application log tells you the user for the application pool, but if you miss it you can look in IIS for the applications pools. Be warned though as PerformancePoint defaults to a GUID for the name of the Application Pool.

I set the permissions for the service account and everything is flying along now..happy days.

Page List

Page List