How to easily limit the number of rows in your Excel Power Pivot model
User Rating: / 0
Written by Erik Svensen   
Tuesday, 08 October 2013 22:09

I am currently working with an Excel Power Pivot model with about 20+ million rows in the model, and as there are a lot of Excel reports in the model and some of the calculated fields are pretty complex it takes some time when I move calculated fields, format them or change them.

The model retrieves data from a SQL database so the table queries are either Stored Procedures or handwritten SQL statements.




XL Cubed