PowerPivot Capacity Specification

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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

Maximum Capacity Specifications

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)

Warning

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