When you choose Power Pivot as the data source, the next step of the wizard displays as illustrated in the following figure.
To connect to a SharePoint PowerPivot Excel file:
1. Do one of the following:
- In Enter Server Path, enter the path of the SharePoint server. Then, in Select a Site, choose the SharePoint site, and in Select an Excel 2010 File choose the Excel pivot table.
- In File Path, enter the URL to the Excel pivot table.
2. Click Finish.