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.

     

     

bideveloper555's avatar
bideveloper555
Helper IV
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.