Video - Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo

Written by Dan English

Monday, 30 July 2012 20:28

I just wanted to do a blog post to demonstrate a performance situation I ran into last week. I had created a PowerPivot model in Excel 2013 and it performed very well (quite the understatement, phenomenal) when creating PivotTables and Power View reports. I then went ahead and recreated the model in Excel 2010 with the SQL Server 2012 PowerPivot add-in. The model creation went fine, but when it came to trying to replicate the report I ran into a slight snag. Well I actually couldn't even complete the report, I ran out of memory on a box with 8GB of memory.