We have users trying to use Performance Point and need to point to a local PowerPivot file as a data source. The instructions state:

 Type the connection string to the PowerPivot data source by using the following format: PROVIDER=MSOLAP;DATA SOURCE=http://contoso/Documents/PowerPivot_Sample.xlsx

Is the Documents a local Sharepoint directory? Im assuming the 'contoso' is the servername, but Im unsure how to give sharepoint access to the files via a URL.


In that case yes, Documents is a document library off the root site collection containing PowerPivot_Sample.xlsx.

In your environment, is the PowerPivot report stored in SharePoint already? If so, navigate to the document library, mouse over the name of the file and right click copy link location. Use that as the url in the datasource.

|improve this answer|||||
  • I will give this a try, I do believe they have uploaded the powerpivot report into Sharepoint. – user5227 Nov 13 '12 at 20:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy