Forum Discussion

POSPOS's avatar
POSPOS
Post Partisan
1 year ago
Solved

How to have multiple roles

Hi All, I have a requirement as below:  I have 5 pages in the dashboard. Pages 1,2,3,4 are coming from Table 1 and Table 2 and Page 5 data is from Table 3. There is a dynamic Row level securit...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi POSPOS,

     

    Thanks for reaching out to the Microsoft Fabric Forum Community.

     

    The only solution I can Think off at the moment is

    Create a User Access Table with a level of access

    "Basic" users can see only Table1 & Table2 (Pages 1–4).

    "All" users can also see Table3 (Page 5).

     

    Then create roles

    For Table1 and Table2:
    LOOKUPVALUE(
    UserAccessControl[Access_Level],
    UserAccessControl[UserID],
    USERPRINCIPALNAME()
    ) IN { "Basic", "All" }


    For Table3:
    LOOKUPVALUE(
    UserAccessControl[Access_Level],
    UserAccessControl[UserID],
    USERPRINCIPALNAME()
    ) = "All"


    If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

    Best regards,
    Prasanna Kumar

     

Deku's avatar
Deku
Super User
1 year ago

The true false would be for table 3. If you want people to only see specific pages I would suggest splitting the report in two, from the same semantic model. Then you can publish as a app and use audiences so that each group with have conditional access to each report/set of pages 

POSPOS's avatar
POSPOS
Post Partisan
1 year ago

Deku  - Our requirement is to have both the cases in the same report as there could also be cases where users assigned to first role and seeing pages 1,2,3,4 could also have access to the page 5. Users could be same for both the roles.