Recently a question has come up on one of the forums about the number of rows that PowerPivot can load. Clearly PowerPivot can hold a lot – just look at our demos. Millions and millions . . ah . . but how many millions?
The key geek ‘magic’ is the Vertipaq engine. The in-memory Vertipaq engine [...]
Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:
The result set must have a name associated with each column. If you are not returning the column [...]