Solved

PerformancePoint Services and Excel Services Connection Problems

Posted on 2012-03-15
3
783 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

735 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