Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
4 years ago
Solved

Avoid RLS to show some measures

hi i have Date table, Fact table ,Dim table and User table. i did create some YOY measure on Fact table . i have 2 visuals. 1 is card showing YOY and 1 is table with sale order information   Car...
Need Help
Show and Tell
  • bideveloper555's avatar
    bideveloper555
    4 years ago

    hi im really sorry to bother.

    i been struggling to implement 2 functionality.

    Both are RLS related.

    1 . As i been above.

    2. i dont want to add every single email addres in power bi service to give permission.

     

    user table:

    ID  emailaddress           admin 

    1   [email protected]           0

    2    [email protected]           1

     

    I need to implement RLS,we have 1000s of user and every user need to see the data which user name is connected to fact table but some user(lets say admin) need to see all the users data.

    if i need to make group per user, i can make it but just need to know. how every thing is connected.

    i been using USERPRINCIPALNAME () in manage roles.

     

    Thanks in advance.

     

     

sirlanceohlott's avatar
sirlanceohlott
Advocate III
4 years ago

Hey bideveloper555 ,

 

What you could do as a workaround is you could have 2 FACT Tables, 1 with RLS applied to specific users & 1 with RLS for the card and everyone is in a management level group where they can see all values.

 

This would be able to get around the issue you are experiencing where you want 1 visual to be RLS and the other visual card to be the entire FACT table.