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.