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

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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