PowerPivot 2010 with SQL Server 2008 data


  • I have data on SQL Server 2008 r2 and want to use PowerPivot for Excel 2010 to analyze it. PowerPivot requires me to import all the data prior to building a pivot table (a 5 hour process). Is there a way to link to the SQL data directly (no import) in a way similar to setting up a "normal" Excel pivot table to access external data?
    Thursday, July 18, 2013 4:09 PM