Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

PerformancePoint Services and Excel Services Connection Problems

Posted on 2012-03-15
3
Medium Priority
?
818 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

886 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