SSAS Tabular : User in two security roles with rows security filters and object-level security filters RRS feed

  • Question

  • I am implementing a dynamic filter in roles that I have in my SSAS Tabular cube. I have a user that is in two different roles.

    If I test my data using this user only in one role everything returns as expected, but if the user is in two different roles I get the following error.

    The combination of active roles results in a dynamic security configuration that is currently not supported. Please contact the administrator of the database to resolve this issue. (Microsoft SQL Server 2017 Analysis Services)

    I have rows security filters and object-level security filters.

    This error appears to anyone? Anyone knows how to pass through this issue?

    Thanks for all your help.

    -- Ricardo Castro

    Thursday, October 29, 2020 1:54 PM

All replies

  • Hello Ricardo,

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    Sreekanth Nadendla
    Microsoft Windows Open Specifications
    Thursday, October 29, 2020 3:41 PM
  • Thanks  S Nadendla,

    I Will Open this question on the forum you sugest.


    -- Ricardo Castro

    Thursday, October 29, 2020 7:31 PM