Analysis Services resource and object limits
This article describes resource and model object limits.
For Query Processing Units (QPU) and Memory limits for developer, basic, and standard tiers, see the Azure Analysis Services pricing page.
These limits are theoretical. Performance will be diminished at lower numbers.
|Databases in an instance||16,000|
|Combined number of tables and columns in a database||16,000|
|Rows in a table||Unlimited
Warning: With the restriction that no single column in the table can have more than 1,999,999,997 distinct values.
|Hierarchies in a table||15,999|
|Levels in a hierarchy||15,999|
|Key Columns in all table||15,999|
|Measures in tables||2^31-1 = 2,147,483,647|
|Cells returned by a query||2^31-1 = 2,147,483,647|
|Record size of the source query||64 K|
|Length of object names||512 characters|
Submit and view feedback for