SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have uploaded a PowerPivot workbook to the PowerPivot Gallery and I am now attempting to use it as a data source for PerformancePoint, but I keep receiving the following error when making the connection in Dashboard Designer:

An error occurred connecting to this data source. Please check the data source for any unsaved changes and click on Test Data Source button to confirm connection to the data source.

The file is not open and the Test Data Source button is greyed out. What is the proper URL syntax? I'm not sure if the URL is the problem either. Any help would be appreciated.

share|improve this question
Did you add it as a trusted source? – Mike Nov 13 '12 at 22:19
I'm experiencing the same issue described here. Does anyone have the resolution? I'm hoping the install described at… will be useful. I'm not an admin so I cannot install it myself. Before I ask the admins to drop what they are doing and try something are there other ideas? – user18886 Aug 13 '13 at 14:37

too late a response but anyway

i resolved the issue by increasing the max limit for excel services to required level. By default its 10MB and the powerpivot files are much larger.

SharePoint Central Administration, and go to Application Management > Manage Service Applications > ExcelServiceApp > Trusted File Locations and click on the appropriate Address. Under the Workbook Properties section you will see a Maximum Workbook Size

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.