Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have uploaded a PowerPivot workbook to the PowerPivot Gallery and am now attempting to use it as a data source for PerformancePoint, but I keep received 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 grayed 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 denglishbi.wordpress.com/2012/02/09/… 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

1 Answer 1

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

 
discard

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.