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

 

i did create second fact table and created measure but fact table 2 i didnt make any relationship to user table. thinking this would work.

but it didnt work.

Are there any resource on this scenario?

sirlanceohlott's avatar
sirlanceohlott
Advocate III
4 years ago

Hey bideveloper555 ,

Probably need to make a relationship between the user and FACT table 2 you've created and then create the new RLS management level group so all your users would be able to see the information for the page you've created!

 

Not sure if I've seen any resources on this, but if I've got some time later on I might be able to make a dummy report that would show the process.