none
Azure SSAS data limit RRS feed

Answers

  • Hello,

    In Analysis Services Tabular mode, it only has some number limitations on Databases in an instance, Tables in a database, Columns in a table, etc. There's no limitation on rows in a table. But it still applies the restriction that no single column in the table can have more than 1,999,999,997 distinct values. For the total size of data, there's no limitation.

    For more details, refer “Analysis Service resource and object limits” and “SSAS – Maximum capacity specifications”.

    Hope this helps.      

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Monday, September 23, 2019 6:42 AM
    Moderator

All replies

  • Hello,

    In Analysis Services Tabular mode, it only has some number limitations on Databases in an instance, Tables in a database, Columns in a table, etc. There's no limitation on rows in a table. But it still applies the restriction that no single column in the table can have more than 1,999,999,997 distinct values. For the total size of data, there's no limitation.

    For more details, refer “Analysis Service resource and object limits” and “SSAS – Maximum capacity specifications”.

    Hope this helps.      

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Monday, September 23, 2019 6:42 AM
    Moderator
  • Hello,

    Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.

    Tuesday, September 24, 2019 10:00 AM
    Moderator
  • Hello,

    Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

    Friday, September 27, 2019 6:14 AM
    Moderator