Power Pivot

When you choose Power Pivot as the data source, the next step of the wizard displays as illustrated in the following figure.

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 File choose the Excel pivot table.

·         In File Path, enter the URL to the Excel pivot table.