Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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
v-cherch-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous 

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.
Anonymous
Not applicable

I tried this also but not working !!

 

RLS4.JPG

 

Anonymous
Not applicable

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 

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.