Capacity management - PerformancePoint Services limits

Limit	Maximum value	Limit type	Notes
Cells	1,000,000 per query on Excel Services data source	Boundary	A PerformancePoint scorecard that calls an Excel Services data source is subject to a limit of no more than 1,000,000 cells per query.
Columns and rows	15 columns by 60,000 rows	Threshold	The maximum number of columns and rows when rendering any PerformancePoint dashboard object that uses a Microsoft Excel workbook as a data source. The number of rows could change based on the number of columns.
Query on a SharePoint list	15 columns by 5,000 rows	Supported	The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SharePoint list as a data source. The number of rows could change based on the number of columns.
Query on a SQL Server data source	15 columns by 20,000 rows	Supported	The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SQL Server table data source. The number of rows could change based on the number of columns.