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: