Solved

PerformancePoint Services and Excel Services Connection Problems

Posted on 2012-03-15
3
754 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

861 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

23 Experts available now in Live!

Get 1:1 Help Now