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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.