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

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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.

Read more...

Tags: performance, excel, tabular

 

2007-2015 VidasSoft Systems Inc.