Forum Discussion

Ybam's avatar
Ybam
Icon for Helper I rankHelper I
4 years ago
Solved

RLS with multiple filters and values

Hello,  We've created a data model in PBI with multiple fact tables linked with dimension tables. We've a web application in which we can define permissions for a user to see data of one or sev...
Data Protection
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Ybam , As long as you can create a table with email id and project which user can access you can filter.

     

    Create a table like

    Project Id ,email

     

    This can have m-m join with project table

     

    You can have another table

     

    Team - email Id

     

    This can have M-M join with Employee/team /person table

     

    Make sure it filters the dimension

     

    in RLS you just need filter email of these table

     

    [email_id] = userprinicpalname()

     

    How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Ybam , As long as you can create a table with email id and project which user can access you can filter.

 

Create a table like

Project Id ,email

 

This can have m-m join with project table

 

You can have another table

 

Team - email Id

 

This can have M-M join with Employee/team /person table

 

Make sure it filters the dimension

 

in RLS you just need filter email of these table

 

[email_id] = userprinicpalname()

 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk