cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MahmoudDoudah Regular Visitor
Regular Visitor

Row-Level-Security Reports: by user Function

 

  • 2) Row-Level-Security Reports:

 

  • I am already Applying the RLS by creating Roles:

 

 

  • & assign them to specific LAN-Active Directory users & groups.

 

 

But the data-model I am working on is different & we have to change RLS methodology in order to meet the data-model structure , save time & offers as-well.

 

data-model structure NOW is having LAN USER ID fo each records

so have to create only role by ENDUSERFUNCTION..

Kindly advice 

  • 3) Chart-Security Reports:

 

How we can make security roles on specific chart only?

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Row-Level-Security Reports: by user Function

Hi @MahmoudDoudah 

It seems you need to use RLS to restrict the data model.For further,please refer to below posts.

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MahmoudDoudah Regular Visitor
Regular Visitor

Re: Row-Level-Security Reports: by user Function

Hi @v-cherch-msft 

 

Really appreciated your cooperation & support

I complete 50% of my issue 

(which are each user can check his own data) RLS1.JPGRLS2.JPGRLS3.JPG

 

 

 

a

 

another 50%

(which are each Manager can check his employees !!

 

when I view role it show no result 

because no employee manager for him self !!

 

>>can`t do it by DAX

because seems like it doesn`t acceppt or "||" intead of "&&"

like query

 

Kindly advice 

 

MahmoudDoudah Regular Visitor
Regular Visitor

Re: Row-Level-Security Reports: by user Function

I tried this also but not working !!

 

RLS4.JPG