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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.