Forum Discussion
Post PartisanHow to have multiple roles
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
Post PartisanDeku - This is what I have for role 1:
I want to create another Role 2, Not sure what code I should be using for Role 2 and where I should be mentioning True () or False()
Note: All users assigned to Role 1 should only see page 1,2,3,4. Only users assigned to Role 2 should be seeing page 5. Also we do not have user name or user id in Table3.
Can you please provide detailed steps
Super UserThe 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