Solved

PerformancePoint Services and Excel Services Connection Problems

Posted on 2012-03-15
3
740 Views
Last Modified: 2012-06-22
When I launch the Dashboard Designer, point to my SharePoint site, choose the document library, the excel workbook, and type in the item name, I'm greeted with the following messege when I hit the Test Data Source button:

Dashboard Designer could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

As far as I can tell, The PerformancePoint Service Application is setup correctly. The unattended service account has read access to the document library where the workbook is stored.

I did do a search and looked at some of the other suggestions other people have tried, but I still haven't had any luck.

Any help would be appreciated.
0
Comment
Question by:DxtrLws
  • 2
3 Comments
 
LVL 7

Expert Comment

by:withtu
ID: 37728287
Have your Excel Services configured successfully and working properly? This is a general permission issue with Excel Service and better to work with it firstly. You'd better to double-check all permissions in your configurations, and grant higher permission for troubleshooting if necessary.
0
 

Accepted Solution

by:
DxtrLws earned 0 total points
ID: 37735205
withtu,

Thanks for the follow up. I was able to figure out why it wasn't working. I have excel 2007 and it looks like you have to type in the "named range" on the worksheet you're trying to use. Otherwise, you'll receive the error mentioned in my original question.
0
 

Author Closing Comment

by:DxtrLws
ID: 37756267
When adding an 2007 excel workbook as a data source in PerformancePoint services, you have to type in the "named range" of what you want to connect to. If misspell the named range, you will receive the error mentioned in my questions.  With excel 2010, the named ranges will auto populate from the drop down menu and you can easily add it as a data source.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now