Forum Discussion

POSPOS's avatar
POSPOS
Icon for Post Partisan rankPost 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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi POSPOS,

 

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution  it helps others who might face a similar issue.

 

Warm regards,

Prasanna Kumar