What is the limit of Members in a single role for Tabular Model in SSAS

Sukanya Parisa 0 Reputation points
2023-03-14T10:00:00.84+00:00

I have a tabular model which contains single Role.

we have around 1820 members under the single role , and we refresh the users list everyday according to Active Directory.

if the users limit reaches more than 1820 users then the Tabular Model is corrupting automatically.

this issue I am getting in SSAS tabular 2017 version, for 2019 it is throwing error message from visual studio as if the limit is greater than 1820 ..I would like to know what is the limit of Members for single Role of a Tabular Model.

If there is a limit how we can increase it ?

User's image

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,241 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 40,576 Reputation points
    2023-03-14T10:51:48.8966667+00:00

    There is a document Maximum capacity specifications (Analysis Services), but it don't mention a user/role limitation and I haven't see an other doc regarding this.