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

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.

share|improve this question

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.

share|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 posting your answer, you agree to the privacy policy and terms of service.