Forum Discussion

Chema_Ortega's avatar
Chema_Ortega
Helper III
6 years ago
Solved

DINAMIC SECURITY

Hello eveybody,   Thanks a lot in advance for your help.   I am trying to implement security row level (I have many users and many Projects in one .bix). The client wants security by project (som...
Need Help
Show and Tell
Tutorial Requests
  • M_L's avatar
    M_L
    6 years ago

    I would suggest you set-up dynamic row level security - you would need to follow these steps 

    - create a table (i.e. T_Sec) with 2 columns UserID & Projects. The UserID should be the email used for the user to access to PowerBI 

    - in Desktop > Modeling> Manage Role, create a role, then in Table "T_Sec" of the "Manage Roles" view, in "Table Filter DAX expression" enter this DAX formula : [UserID] = USERPRINCIPALNAME()

    - in Relationship view of Desktop, set-up the relationship (many-to-many) between the table T_Sec [Projects] to tables you want to limit visibility by projet 

    - then in Power BI Service, assign this role to the user and give them access 

    Please mark it if this works. 

M_L's avatar
M_L
Frequent Visitor
6 years ago

I would suggest you set-up dynamic row level security - you would need to follow these steps 

- create a table (i.e. T_Sec) with 2 columns UserID & Projects. The UserID should be the email used for the user to access to PowerBI 

- in Desktop > Modeling> Manage Role, create a role, then in Table "T_Sec" of the "Manage Roles" view, in "Table Filter DAX expression" enter this DAX formula : [UserID] = USERPRINCIPALNAME()

- in Relationship view of Desktop, set-up the relationship (many-to-many) between the table T_Sec [Projects] to tables you want to limit visibility by projet 

- then in Power BI Service, assign this role to the user and give them access 

Please mark it if this works. 

  • Chema_Ortega's avatar
    Chema_Ortega
    Helper III
    6 years ago

    HI M L,

     

    Thanks a lot. It seems to be working!!! Great!!!

     

    Just one point: when I enter witn a user with Administrator rights, I can see everything. When I enter with a user with security applied, and the Table I want to show is in Direct Query, the visualization breaks down. I don´t know why... It doesn't make sense at all!!!

     

    Best regards,

     

    Chema