I am working on a PowerPivot based analysis design and my data source is a SQL Stored Procedure which does the following: 1. Inserts set of records from one DB into a Table Variable

See more here:
Stored Procedure as Data Source in PowerPivot – Issue & Solution