Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PowerPivot Capacity Specification

The following table specifies the maximum sizes and numbers of various objects defined in PowerPivot components.

Object

Specification / Limit

Object name length

100 characters

Invalid characters in a Name

. , ; ' ` : / \ * | ? " & % $ ! + = () [] {} < >

Number of tables per PowerPivot database

(2^31) - 1 = 2,147,483,647

Number of columns and calculated columns per table

(2^31) - 1 = 2,147,483,647

Number of calculated measures in a table

(2^31) - 1 = 2,147,483,647

PowerPivot memory size for saving a workbook

4GB = 4,294,967,296 bytes

Concurrent requests per workbook

6

Local cubes connections

5

Number of distinct values in a column

1,999,999,997

Number of rows in a table

1,999,999,997

String length

536,870,912 bytes (512 MB), equivalent to 268,435,456 Unicode characters (256 mega characters)

Caution noteCaution

Exceptions to the string limit apply to the following functions, where strings are limited to 2,097,152 Unicode characters:

  • CONCATENATE and infix concatenation operator

  • DATEVALUE

  • EXACT

  • FIND

  • FORMAT

  • LEFT

  • LEN

  • LOWER

  • MID

  • REPLACE

  • REPT, restriction applies to the input parameter and the result

  • RIGHT

  • SEARCH

  • SUBSTITUTE, restriction applies to the input parameter and the result

  • TIMEVALUE

  • TRIM

  • UPPER

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.